0 Replies Latest reply: Apr 26, 2012 6:38 AM by Sonika Jain RSS

    display row for all others total in a pivot table

    Sonika Jain

      Dear all,

      I am stuck in a scenario where I have to display top 50 rows for a measure in a pivot table, then display the total of 50 rows, and then a row for total of remaining rows (others).

       

      I can see an option of 'others' been combined for pie and bar charts, but cannot find anything for pivot tables.

      Please suggest ways of implemetation.

       

      Thanks