Pivot Table: User - controlled dynamic sorting

Milaf — Mon, 13 May 2024 06:32:29 GMT

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.

Re: Pivot Table: User - controlled dynamic sorting

Milaf — Wed, 15 May 2024 05:53:43 GMT

+Up 😞

topic Re: Pivot Table: User - controlled dynamic sorting in App Development

Pivot Table: User - controlled dynamic sorting

Re: Pivot Table: User - controlled dynamic sorting