- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please refer the link below.
Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nobody any idea?
Or is it unclear what I want?
Kind Regards,
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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