Skip to Content
Former Member
Sep 28, 2009 at 04:44 PM

Top N report customization



I am working on a report which has 8 key figures. The last key figure is sales and I want to build a report which will display the top 20 customers by sales. Along with this I also want to display the sales to the rest of the customers as the 21st row in my report. This is where I am stuck. I can create a report with top 20 condition but I don't know how to insert the 21st row which will calculate and display the sales to other customers as defined by total sales - sales to top 20 customers.

I will greatly appreciate any help you can provide.