ALKA
Occasional Contributor

Dynamic ranking not working

Hi Community,

我试图基于连接的两个等级dimensions and rank doesn't seem to be working.

However, when I remove "group by" condition from rank formula, it ranks. Why is it so?

Can somebody explain please?

ALKA_1-1645370749678.png

ALKA_2-1645370845337.png

Thanks

Alka

1 ACCEPTED SOLUTION

Accepted Solutions
anikdas
Certified Master Anaplanner

Hi@ALKA

The group by column has different values for all the list items. That means there is only 1 item per group element. Hence, the rank becomes 1 for each of them.

Please revisit the grouping and it should work.

Thanks
Anik

View solution in original post

2 REPLIES2
anikdas
Certified Master Anaplanner

Hi@ALKA

The group by column has different values for all the list items. That means there is only 1 item per group element. Hence, the rank becomes 1 for each of them.

Please revisit the grouping and it should work.

Thanks
Anik
ALKA
Occasional Contributor

Thanks for helping@anikdas, Understood!