Revenue Total

[Anonymous]

A very easy question I thought I'd never have to ask... but at the bottom of this table, how can I display the total of all revenue? When I change the field from 'Don't Summarize' to 'Sum', it gives the total on each and every line. Not what I'm looking for:

[Greg_Deckler]

So does the first table represent the source data?

[Anonymous]

@Greg_Deckler That is correct.

[Greg_Deckler]

OK, that's very strange. I don't see that. Since I wasn't going to retype your table by hand (post data in a format that can be copied):

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

But, I created 3 lines like this:

Company IDDelta AccountRevenue

EMS-0100	Woods Rogers PLC	$60,739.15
EMS-0181	Carlisle School	$33,972.23
EMS-0340	Yale Carolinas, Inc	$71,676.6

And I got this:

Not sure what is going wrong on your end, but ?