Forum Discussion
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 ...
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
Perhaps you need to use nested interators to ensure values are calculated on the right level.