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

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Greg_Deckler This is nice but seems a little complicated for what I'm trying to achieve? I just need my rows to stay put while the grand total of all revenue is at the bottom. There are no measures being calculated:



I then attempt to sum all revenue

danextian's avatar
danextian
Icon for Super User rankSuper User
8 years ago

Hi Anonymous,

 

Did you create a calculated column from the sum of revenue? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    danextian I believe so. In the query editor there were multiple revenue amount for each account so I grouped everything by the company id and summed by the revenue column. I didn't need each individual payment amount for each company, but just what the totals were for each account.