Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a pivot table with top and bottom ranking. Not thru dimension limits but with rank function in the expression. However when I try to sort it Top 5 records works well but bottom sorting do not work. I want top to be descending and bottom to be ascending order.
Hi
In this case I believe you will have to create a variable and through that variable you control the rank in descending order by inverting the signs
for example, it would look something like
if(var_1='Top 5',
sum(value),
sum(value) * -1)
you can control the display of formatted or color negative sign
Regards