2 Replies Latest reply: Jul 5, 2012 10:50 AM by Carmen Turnagiu

# sum of top 5

Hello,

I have data representing the Sales by Products, by Companies.

I would like to create a chart to show for each Product total Sales made by top 5 Companies for that specific Product. Also I would like to calculate and display the percentage that total Sales made by top 5 Companies represent out of total Sales for that product (all Companies).

ProductSales Top 5 CompaniesTop5/Total
Product A150025%
Product B300010%
Product C800080%
Product D20003%

Please can you help with correct expressions for the chart columns?

The expression i have used for Sales Top5 Companies is sum( {\$<Company>={"rank(aggr(sum(Sales),Company))<=5"}>} Value) but as far as I could see is correct only if single Product is selected.

Thanks!

Carmen

• ###### Re: sum of top 5

If you have a sum expression you can use dimension limits, you can set the limitation to select the top 5 or top 10 or bottom 5 etc, in QV 11 you can be even more specific. this will produce the answers you are looking for.

Hope this helps?

Thanks Steve

• ###### Re: sum of top 5

Hi Steve, thanks for the reply.

Client wants a chart such as in my previous example, in order to be able to depict products for which more than 80% of the sales are made by only 5 companies.

I've tried to use dimension limits but in this case I am only able to display value of sales for each  company from top5 but I cannot calculate the percentage ( sales made by top5 companies/ sales made by all companies)

I hope I was able to explain more clear what I need.

Thanks,

Carmen