Sort Pivot Table

[#1]

Hi Experts

I generated a Pivot Table. I would now like to sort for another value than my dimension.

Is that possible? If yes, how?

Thank you for your help!

Jan

[alexandros17]

Uncheck Y-Value and use your expresison in the expression box to sort rows ...

[#3]

But under "Sort" I am only able to sort my Dimension, no other value...

[alexandros17]

there is a check box "Expression" ...

[#5]

Could you send me a picture? I am not sure which option you are refering to... This is what I see...

[alexandros17]

[#7]

Sorry, can not see the picture...

[alexandros17 · Accepted solution]

The box to be checked is "Formel"

[#9]

AWESOME! Thank you!