How to Sort Pivot (column with formula) from largest to smallest percentage

[#1]

Hi Guys,

Can you help me, how to sort an existing pivot column formula from largest to smallest percentage.

Please find attached the sample data.

Thanks & Regards,

Valdi

[#2]

Goto Sort Tab, Select Y Value, Descending.

[#3]

[Anonymous]

Hi,

Copy the expression and paste it in sorting tab's expression box for Sales dimension. Make a sorting in descending order.

Another option, you can check "Y-value" by Descending order.

[#5]

i'm sorry, Please find attached, how to sort column % YTD

[Anonymous · Accepted solution]

Hi,

As I mentioned earlier, Copy/Paste your %YTD expression in sorting tab expression box and make the order descending.

Hope it helps you.

Satya

[#7]

PFA. Sorting by %YTD.

[#8]

Hi Satya,

your answer is correct, but I have a problem when the name of the sales "-" or null which is above the line, not in order of the percentage >.<

[#9]

i can't see any null or '-'. Can you attach a screenshot?

[#10]

Hi Mr. Ramkumar & Mr.Satyadev

Thanks for your help