Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Revenue Total

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 ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    Anonymous

     

    Hi, try changing in the relationship Cross Filter Direction to BOTH

     

    Regards

     

    Victor

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.