29 Replies Latest reply: Oct 15, 2012 5:12 AM by Rahul Lakhina RSS

    Pivot with Top 10 customers AND...

      I would like to show the sales revenue of the top ten customers (ranked by revenue). I have solved this.

      Also I would like a subtotal of these, and on the next row, the subtotal of all the other customers (number 11 and up).

      At bottom I would like a grand total for all customers, (number 1 and all).

       

      So..

       

      Customer 1

      Customer 2

      .

      .

      Customer 10

      SUBTOTAL TOP 10

      ALL OTHER CUSTOMERS

      Grand TOTAL

       

      Can anyone please help?

       

      Thanks!

      NorTor

      Norway