Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Goto Sort Tab, Select Y Value, Descending.
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.
i'm sorry, Please find attached, how to sort column % YTD
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
PFA. Sorting by %YTD.
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 >.<
i can't see any null or '-'. Can you attach a screenshot?
Hi Mr. Ramkumar & Mr.Satyadev
Thanks for your help