topic Re: Rank Function for a measure based on 2 different dimensions and aggregating on one in App Development

Rank Function for a measure based on 2 different dimensions and aggregating on one

Sathvik — Fri, 24 May 2024 08:51:45 GMT

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.!

Re: Rank Function for a measure based on 2 different dimensions and aggregating on one

TauseefKhan — Fri, 24 May 2024 10:35:45 GMT

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.

Re: Rank Function for a measure based on 2 different dimensions and aggregating on one

Sathvik — Fri, 24 May 2024 10:40:38 GMT

Hi @TauseefKhan

Thank you for the response, I have tried this response as well but it is still getting aggregated on City.

Re: Rank Function for a measure based on 2 different dimensions and aggregating on one

TauseefKhan — Fri, 24 May 2024 10:48:51 GMT

Check This:

Rank(aggr(Sum({<Flag={'Product-A'}>} Sales), Dual(ProductName & ' - ' & City, ProductName, City, X)))