How to do sums of columns show in pies and tables

[Jay2077]

Can anyone help, I simply want to show costs across groups ie 

A pie showing 

Team A = £250,000 (caluclating all team a entries)  

Team B = 50,000

and a table also,  as it is it just counts the entries like so 

Team A = 89 

Team B 45 

Any help greatlt appreciated

[v-piga-msft]

Hi @Jay2077,

I'm still a little confused about your scenario.

If it is convenient, could you share some data sample and your desired output so that we could help further on it?

Best Regards,

Cherry

[sokg]

Can you provide us with sample data???