Pivot Table Bottom sorting

[tellmalaika17]

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.

[Yoshidaqlik]

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