Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
As much as I searched, I can't find the answer.
I've a table with a single dimension, StoreCodeDesc, and I want to know the weight of the top 100 of the best selling products on the total sales of each store.
On the one hand I want to know the weight that the Top 100 global has, I use the formula:
Sum ({<ArticleCode = {'= rank (Total Sum (NetAmount)) <= 100'}>} NetAmount) / sum (NetAmount)
For another hand I want to know the weight of the Top 100 of each store with the formula without Total:
Sum ({<ArticleCode = {'= rank (Sum (NetAmount)) <= 100'}>} NetAmount) / sum (NetAmount)
Both formulas give me the same result, the weight of the top 100 global sales of each store, but I don't get the weight of the top 100 of each store.
Any ideas?
Regards
For each store, you can try this
Sum(Aggr(If(Rank(Sum(NetAmount)) <= 100, Sum(NetAmount)), Store, ArticleCode))
Thanks, it works perfectly.