Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
chriys1337
Creator III

Custom Sort Order in a Pivot

Hi,

I am having a multi Dimension and Expression Pivot, where the Dimensions looks like this:

1. Customer, 2. Validity, 3. Area, 4. Named Account.

The order of these 4 dimensions should stick like they are, BUT I want to sort  following priorities 1. Customer alphabetically, 2. Named Account alphabetically and THAN!! 3. Area alphabetically and 4. Area alphabetically.

The special thing on this sorting is, that the order of the 4th column is 2nd important and not the 2nd or 3rd one first!

My table should like this:

Customer, Validity, Area, Named Account

HRS, Longtime, Europe, Agoda

Ikea, Shortime, Africa, Agoda

Lubo, Shortime, Europe, Belkin

Friedrich, Midterm, Europe Z-Company

Golo, Midterm, Asia, Z-Company

Can anybody please help me with this?

Kind Regards,

Chris

4 Replies
techvarun
Specialist II

chriys1337
Creator III
Author

Hi,

I did not find the solution for my problem.

I want to change to sort order, my 4th column should be second important. But the original sequence of columns should stay the same, regardless of the defined sorting order.

Anybody did this before?

kind Regards,

Chris

chriys1337
Creator III
Author

Nobody any idea?

Or is it unclear what I want?

Kind Regards,

Chris

scottyleung
Partner - Contributor

By using the Pivot Table, It can only sort the first dimension ( not matter depends on what conditions) then the second dimension and so on.

Now the question will be how you sort the dimension, you can choose sort by expression and use aggr function to sort by the value you want to.

But in your problem, I cannot see it is applicable to use pivot table. You can use straight table for it.

Cheers,

Scott