Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have been working on Ranking a product, what is the rank of the product individual city level when compared to its competitor product.
Rank(aggr(Sum({<Flag={'Product-A'}>}Sales),Month, X, city))
Here, X = Our Company + Competitor Companies (Club)
when the above formula is applied the aggregation is happening on all cities and not on X which is failing the purpose of the use case where I want to see the Ranks of X at each city.
Please let me know how can I achieve this.
Thanks in advance.!
Check with This:
Rank(aggr(Sum({<Flag={'Product-A'}>} Sales), City, X))
Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
Hi @TauseefKhan
Thank you for the response, I have tried this response as well but it is still getting aggregated on City.
Check This:
Rank(aggr(Sum({<Flag={'Product-A'}>} Sales), Dual(ProductName & ' - ' & City, ProductName, City, X)))