3 Replies Latest reply on May 16, 2018 2:05 PM by Andrew Shen

    How to group index data into a high level summary?

    Andrew Shen

      With this data set I want to make a new sheet that shows in groups what the Avg Profit and Total Profit are. The groups I want to base of the index function to show top 20, top 40, and top 60.

       

      The problem I have is classifying the index values and losing the rows. I can group with all the rows present, but I need to lose the detail rows and just show the high level by "top 20", "top 40", etc. and drop the state and customer name detail.

       

      Thanks,

      Drew