Forum Discussion

CAPEconsulting's avatar
CAPEconsulting
Icon for Helper III rankHelper III
6 years ago

Rankx and summarized table

I have a complex table where a column is flagged as denominator based on some variables and another column is flagged as numerator based on other criteria. Then a measure of proportion is calculated ...
CAPEconsulting's avatar
CAPEconsulting
Icon for Helper III rankHelper III
6 years ago

See using what I have the measure is still ranking an entity that has denominator less than 10.

 

 

 

Also please see top 5 table works fine but when territory is introduced it goes haywire

 

And it does not show just the top 5 anymore but starts showing all entities even though the measure uses top 5

 

 

 

stevedep's avatar
stevedep
Icon for Memorable Member rankMemorable Member
6 years ago

Perhaps you need to use nested interators to ensure values are calculated on the right level.