3 Replies Latest reply: Mar 3, 2016 4:12 AM by Liron Baram RSS

    Grouping data in my pivottable

    Guillermo Lo-Kioeng-Shioe

      Hi Guys,

       

      I have a question about the following:

       

      I have this table with 100+ organizations and their data. What i would like is to show the top 30 performers and group the rest as 'other' which should be the sum of the last 70+ organizations.

       

      I hope my question is clear and you guys can help me out.

       

      (I am using a pivot table btw)

       

      Thanks in advance.