How do I sort column total in pivot table?

November 12, 2014 at 04:07:48
Specs: Windows 7
I have a column of total on the right of pivot table. after doing subtotals based on first column values. Now I need to sort this last column of results from up to down and I don't want to copy the pivot table with values. I just need the subtotals to be sorted, taking the releavnt data with them... Hope I managed to explain. I can attach the file if it's possible

See More: How do I sort column total in pivot table?

Report •

#1
November 12, 2014 at 04:16:36
Look here and see it helps, this is for Excel 2007

https://office.microsoft.com/en-us/...

MIKE

http://www.skeptic.com/


Report •

#2
November 12, 2014 at 04:47:08
Hi. IT is not helpful unfortunately. I did subtotals and collapsed. Now I need to sort the collapsed values in right column. thanks

Report •
Related Solutions


Ask Question