Pivot Table: User - controlled dynamic sorting

[Milaf]

Hello everyone,

I read a lot of posts on pivot table dynamic sorting, but I couldn't do exactly what I wanted to do. I have 3 dimension and a single measure field in the pivot table, but the user wants to be able to sort ascending or descending. I wanted to select it like a button with variable input, but I didn't get what I wanted.

For dynamic values;
1- I defined variable
2- I wrote this formula in the object: = 'SUM(Qty)~ Descending'
3- I defined Sorting

But this way I only have one button. Normally I want an Ascending/Decreasing (it doesn't matter) sorting to come, I want it to change every time I press it.

I would appreciate your help.

[Milaf]

+Up 😞