Top 3 Products Concentration

[coerdn]

Hi together,

i want to build up a kpi for the top 3 export products concentration based on the whole product range. 

So i have Product A B C D E F and want to sum up the sum of sales for the top 3 and calculate the sales concentration for these three products.

 already sorted the products with a rank expression:

RANK(Sum({<[Product]={'Export'}>}[Sales]))

But i dont know how to build the sum dynamically for the top 3 products.

Can anybody help me?

many thanks in advance. 

[Kushal_Chawda]

@coerdn  did you try with limit dimension value to Top 3 option?

[coerdn]

Hi kush,

thank you for your response. But i want to use a calculated kpi. which chart type do you use in your example?

[Kushal_Chawda · Accepted solution]

@coerdn  If you want in KPI then try below below expression

=sum({<Product ={"=rank(sum(Sales))<4"}>}Sales)

[coerdn]

@Kushal_Chawda but then i get the sum of all products not only the top 3 products. 

[Kushal_Chawda]

@coerdn  It should give you sum of top 3 product only if you are using the same expression with correct field names as per your data