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

    Grouping data in my pivottable

      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.