Calculate share of top 10 bestsellers to total revenue

[WillemRR]

Dear,

I would like to calculate the % of revenue that our top 10 products contribute to our total revenue. I already have a table with our top 10 products by using ARTICLE as dimension and Sum of Sales as Measure and used a Fixed number limitation on the ARTICLE dimension.

Is there a way to Sum the sales of these 10 articles and divide them by the total of sales?

[brunobertels]

hi 

Try this for top ten 

Sum({<ARTICLE= {"=Rank(Sum(Sales))<=10"}>} Sales)

/ 

Sum( Total Sales)