Discussions

Expand all | Collapse all

How to calculate the data and list the top 5 with others?

  • 1.  How to calculate the data and list the top 5 with others?

    Posted 07-09-2016 08:22
    I had uploaded our three years sales records by customer and item category.  I want to sum sales revenue by categories and create the pie chart that just show top5 items or customers, then sum the rest to "others"?


  • 2.  RE: How to calculate the data and list the top 5 with others?

    Top
    Contributor
    Posted 03-02-2017 06:34
    To do this natively you will need three tables to summarize the data up, and pass more information back down to make your report on the original table.

    You posted this a while ago, so you might have come up with a solution on your own or are you still looking for more guidance?