Custom Sort Order in a Pivot

[chriys1337]

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

[techvarun]

Please refer the link below.

Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)

[chriys1337]

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]

Nobody any idea?

Or is it unclear what I want?

Kind Regards,

Chris

[scottyleung]

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