Forum Discussion
Revenue Total
Anonymous
Hi, try changing in the relationship Cross Filter Direction to BOTH
Regards
Victor
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...
Anonymous Greg_Deckler Here are screenshots step by step of what I did. Maybe one of you can see where I'm going wrong:
And for how my revenue column is modeled:Which gives me this when using 'Don't Summarize'
The moment I change it to 'Sum' on that column
Greg_Deckler Anonymous I don't know if it helps or even matters ( I don't think it should) but the Revenue column isn't in the same dataset as everything else. I have 2 objects that are connected through a unique ID. So the dataset I'm using for the Revenue consists of nothing but a unique ID and the revenue amount associated with that ID. I then created a relationship between the two tables based on the Unique ID's. I'm going to try to delete the relationship and just merge the queries instead on that ID to see if it behaves any differently.
