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

     

     

danextian's avatar
danextian
Super 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.