Rank Based On ALL Dimension Members

[#1]

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.

[#2]

Thanks Stefan!  Works like a charm! 

[Jason_Michaelides]

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