Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, hopefully everybody is good 😎
I would like some help, please, to calculate a nested ranking. I have the expression below to return the Top 40 customers in a synthetic dimension. Now I would like to provide further views but
Is this possible?
Thanks in Advance
NSB
Aggr(
If(
Rank([Sales]) <= 40,
[Customer]
),
[Customer]
)
OK, the following seems to work, but please let me know if you can think of any objections. Also, my back up is to create a top vendor flag dimension in the script but I would prefer it to be dynamic at this point.
Aggr(
If(
Rank(
If(
Rank([Sales]) <=40,
- (Budget Variance])
)
) <= 3,
[Customer]
),
[Customer]
)