4 Replies Latest reply: Jun 21, 2017 1:02 PM by Sunny Talwar RSS

    Aggr/Sum totals by Year

    Linda Pembroke

      Hi,

      I am wanting a simple pivot table that aggregates the total sum of the field 'NUM_STATUS' by the dimension 'Year'. I want it to sum the amount for the entire year though, not just the month/year selected. I've created expressions using set analysis to aggr a single year, but don't want to have to create a new expression for each year.

       

      What is appropriate expression to use in order to sum the total of NUM_STATUS for all years regardless of selections?

       

      Thank you.