Dinamic Sort on Pivot Table

[Anonymous]

Hello!

Is it possible to do some "dynamic sort" in a Pivot Table?

For example, in a Straight Table, double clicking on a dimension, the entire table will be sorted by this dimension.

Is there any way to do (or simulate) it on a Pivot Table?

Thanks in advance,

Gabriel Rocha

[rwunderlich · Accepted solution]

You can use the sort "by expression' option and compute your sort order based on selections or variable values that may be set with buttons. See Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level) for an andvanced example.

-Rob

[Anonymous]

Thanks for the answer, Rob.

I've tried something like this, but nothing so complete as your solution.

But what I was expecting is find a way to do this "sort" with double click or something like this, 'cause our users are used to work this way.

But anyway, thanks for the help.

[lyeynant]

Hi,

You can do that by creating buttons and using Variable and Expression sort functionality.

1. Create variable  vSort  

2. Create n Text objects / buttons as number of expressions you want to sort.

Text Object #1 : Set Actions--> Add --> External --> Set Variable --> Variable:  vSort    Value: 1 

3. In Pivot table --> Sort --> Expression  create follow formula  If( vSort =1 ,  Sum(Sales), If( vSort=2, Count(Order_Id)...))

Good luck,

Anton