Sorting in Pivot table on 2nd dimension

[#1]

Hi,

Please help on sorting the dimension 'code' in desc order, in the file attached on the basis of sum(Amount)

Regards

[lironbaram]

hi attach

is your file with the desired sorting

[#3]

Hi,

it looks correct but what did u do ?

Thanks

[#4]

Hi,

i see that u just used Sort Desc. on first Dimension, but actually i need to keep the sorting of 1st dim intact,

The scrambled values of dim1 makes it difficult so i'm attaching another file with 1,2,3...etc as dim1 values

Please see attached

Thanks for the help

[tresesco · Accepted solution]

See the attached sample.

[#6]

Hi tresesco,

Thanks for the answer.

Is it possible to achieve this in script, may be using some group by ?

Regards