Sort in a Pivot Table (Cross Tab)

[chiranjivdas]

I have a cross table with customers as rows and year as column across the top. Like below

Customer	2012 Revenue	2013 Revenue	2014 Revenue
Customer 1	500	450	600
Customer 2	700	490	585
Customer 3	900	1150	790

How can I sort by 2014 Revenue in descending order?

[Anonymous]

Pivot table is always sorted by dimensions, and the first dimension is Customer.  To solve your problem, you can sort Customer by expression, descending, and expression could be like this:

sum({<Year={'2014 Revenue'}>} Revenue)

[krishna20]

Hi,

Goto Sort Tab-> Select Numeric  and Expression value as Descending.

Regards

Krishna

[Anonymous]

Hi,

Double click on the 2014 year then u can see the sorting type