Sorting in Pivot table with horizontal dimension

[#1]

Hi,

Below you find a screenshot where Dim4 values needs to be sorted such that the range 56t-140t comes after the range 50-55t

but it doesn't.

I tried to associate a number with the combination of Dim3 & Dim4 to achieve this(screenshot below)

Dim4 in the table in screenshot 1 is sorted on the basis of sum(num) but still it doesn't get sorted in correct way for the first value of Dim3

Sorting for other values of Dim3 is ok.

Please help.

Regards

[tresesco]

Can you please share sample app?

[#3]

Please find attached

[#4]

hi, you will notice this is a automatic sorting issue with Excel.  Since this is a text field, it is sorting in such a way.  You should probably rename the field either numerically or alphabetically to get the desired result

[#5]

i've associated the field with a number & did sort by sum(num) but doesn't work.

[Anonymous · Accepted solution]

Use max({1} num)

check attached

[#7]

Hi,

it works

but how does it work ?

please explain

[Anonymous]

The simple reason. We are taking a Max of "num" and sorting it in asc order. so, as the series you have numbered gets sorted in the asc order and using a set we are ignoring any selection to affect the sorting.

hope this helps.

[#9]

why doesn't sum(num) work ?

and why does it behave the way it does ? i hope max equals sum here for each pair of Dim3 & Dim4

also when we select/click any value of Dim3 the sorting becomes ok, why is it so ?