2 Replies Latest reply: Sep 20, 2012 7:45 AM by Rishi Minawala RSS

    Sum of Top 10 Trading Groups with multiple expressions in table chart

    Rishi Minawala

      I am trying to create a chart where I want the sum of all the 'Top 10 Trading Groups' and to use this as a dimension along with a date field

      I then have five expressions such as sum(Sales), sum(supply), etc.... which i want to drive from 'Top 10 Trading Groups'

       

      I have tried the following but does not work.

       

      =sum(aggr(if(rank(aggr(sum(NET_SALE), TRADING_GROUP, ISSUE_DATE))<=10, SUM(NET_SALE)), ISSUE_DATE, TRADING_GROUP))

       

      And then I would like to get all the sales EXCLUDING the Top 10.

       

      Can anyone help?