0 Replies Latest reply: Nov 4, 2010 11:27 AM by Henry Noh RSS

    Total of only TOP 25 and Total of ALL in the SAME STRAIGHT TABLE POSSIBLE?

      I have a chart only showing the top 30 clients and the sum of their sales.

      (used calculated AGGR dimension).

      The total rightly shows the sum of only the TOP 30...but I also need to show the TOTAL of ALL clients right below it.

      IS THIS POSSIBLE? Thanks in advance!

      as an FYI, the calc dimension is:

       

      =aggr(if(rank(sum({<Year={2010}>}Sales))<=30, Client,null()),Client)