Forum Discussion
Revenue Total
Anonymous
Hi, try changing in the relationship Cross Filter Direction to BOTH
Regards
Victor
Hi Anonymous
With the table selected there should be an option to include the total that you should be able to activate:
Not sure if that solves your issue?
Matt
Anonymous Well I would like to have the grand total at the bottom of my table so I need Total turned on. I just don't know why it's changing the individual amount for each row. I want the individual amounts for each company to remain what they are, just with the grand total of all revenue at the bottom.
OK, and with the measure / aggretion set to 'Don't Summarize' and the Totals turned on in the table format, it doesn't do it correctly?
As Greg says, very odd! Apologies I can't be of more help, works fine for me in various different scenarios.
Matt
Anonymous - I think I caught something in his reply that he might be trying to do the sum in Power Query? If that is the case, yeah, he is going to get some weird things happening.
Greg_DecklerCould well be - I've just tried aggregating in Power Query but still working ok, I can't seem to reproduce the error. One thing I've noticed though is that I never have the Don't Summarize option active - doesn't that only appear for text entries?
Perhaps there's a format issue something in the model...
