3 Replies Latest reply on Jan 1, 2014 10:17 PM by Manas Ranjan Kar

# How to calculate the sum of sales of top N products

How do i calculate the sum of sales of Top N products out of all products. which gives me the percentage contribution of sales for the top N products.

In this scenario which i have attached to this post. I need the sum of percentages of top 5 products. so that it gives me the percentage contribution of top 5 products out of overall sales

It would be really great full if some one help me out there.

Message was edited by: krishnaji vadlani

• ###### 1. Re: How to calculate the sum of sales of top N products

Hi Krishnaji,

I'm not sure I understand the desired outcome. Do you want the grand total to be a sum of the top 5 products' percentages? Or do you want to only show one bar for the top 5 products and the grand total?

-Tracy

• ###### 2. Re: How to calculate the sum of sales of top N products

Hi Tracy,

Thanks for your response. I want to customize grand total in such a way that it should show the sum of "Top 5 Products" if 5 is entered. I tried out doing it with adding a reference line such that it will show the sum of top N product percentages.

• ###### 3. Re: How to calculate the sum of sales of top N products

Hi,