Sorting pivot table

[rohitians]

I have a pivot table to analyze sales with previous year i want to sort in desc order according to the expression i.e sales  but it is not getting sorted ....

[sushil353 · Accepted solution]

in the sort tab select the dimension to sort and then put the same expression in the sort by expression.

HTH

Sushil

[Gabriel]

Hi,

To sort in order of your preference follow steps below

right click on the chart > Properties > Sort > check the box beside Expression & click on Expression > click on ecclipse (...) then type

=Match(DIMENSION NAME,’xxx’,'xxxx','xxxx') (xxx stands for name of the order say you have JAMES, MARTIN e.t.c) Don’t forget to enclose each in single quotation mart (‘).

Click ok.

let me know if this is helpful or solve you problem.

Regards,

Gabriel

[VishalWaghole]

Hi,

In sort tab select dimension on which you want to apply sort expression.

Then go to expression box and put your logic in below expression.

IF(Dimension      = '0-12',      '1',

IF(Dimension      = '12-24',    '2',

IF(Dimension      = '24-48',    '3',

IF(Dimension      = '48-72',    '4',

IF(Dimension      = '> 72',      '5')))))

Thanks and Regards,

Vishal Waghole.