Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@coerdn If you want in KPI then try below below expression
=sum({<Product ={"=rank(sum(Sales))<4"}>}Sales)
@coerdn did you try with limit dimension value to Top 3 option?
Hi kush,
thank you for your response. But i want to use a calculated kpi. which chart type do you use in your example?
@coerdn If you want in KPI then try below below expression
=sum({<Product ={"=rank(sum(Sales))<4"}>}Sales)
@Kushal_Chawda but then i get the sum of all products not only the top 3 products.
@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