Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Dinamic Sort on Pivot Table

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?

Gabriel Rocha

1 Solution

Accepted Solutions

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

3 Replies

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
Not applicable
Author

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.

Contributor II

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

Community Browser