Pivot Table sorting by value is inactive.

[fatihtomruk]

Hi,

I have a pivot table and there are there dimentions and four expressions. I want to sort the expression by values from largest to smallest.

Bu at the sort tab, Y-value's tick is inactive. Please help.

Fatih Tomruk

Qliklearners‌

[MayilVahanan]

Hi

In Pivot table, Y - Value sort is enable for first dimension only.

[Anonymous]

Go to sort tab and in that have the expression to give the field name  and it sort

[jagan · Accepted solution]

Hi,

It is available for first Dimension only, instead of that you can use Expression and give your expression there.

Regards,

Jagan.

[fatihtomruk]

Yes,

I wrote a formula in the Expression sort. So It worked.

Thank you.

Best regards.

Fatih Tomruk.