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,
Goto Sort Tab, Select Y Value, Descending.
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
As I mentioned earlier, Copy/Paste your %YTD expression in sorting tab expression box and make the order descending.
Hope it helps you.
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?
Yes, you are right. NULL value always displaying at the bottom. Best way to handle this to interpret these value as "NA" or space.
PFA. Sorting by %YTD.
Hi Mr. Ramkumar & Mr.Satyadev
Thanks for your help
Retrieving data ...