Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have the following rank expression.
=rank(sum(TotalCost),4)
However, is there a way to ignore a dimension selection? So that the rank expression would return the rank based on ALL.
For example, I selected one Partner dimension member. Even though only one Partner would return, I would like the rank expression to rank based on ALL Partner members, not based on the selected members.
Partner Rank
"QlikView" 1
"Microsoft" 2
"Google" 3
Current Result (after filtering on "Google" Partner)
"Google" 1
Ideal Result (after filtering on "Google" Partner)
"Google" 3
Sincerely.
Thanks Stefan! Works like a charm!
Very nice, Stefan. I need to start using Aggr() more as it's come up here a lot recently and seems to be pretty powerful when used correctly.
Jason