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

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      8 years ago

      So does the first table represent the source data?

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Greg_Deckler That is correct.

    • 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.