C cmbyates New Member Mar 8, 2016 #1 I have two years of sales and created a column which calculates the difference. I want to sort for the biggest differences and can't seem to get it to then only sort based on that single difference column descending. Help will be appreciated.
I have two years of sales and created a column which calculates the difference. I want to sort for the biggest differences and can't seem to get it to then only sort based on that single difference column descending. Help will be appreciated.
N Nebu Excel Ninja Mar 9, 2016 #3 Hi: You may want to check these links http://aaron-hoffman.blogspot.com.au/2013/04/microsoft-excel-2013-sort-pivot-table.html http://www.pcreview.co.uk/threads/sort-calculated-field-in-a-pivot-table-an-example.971993/ Thanks
Hi: You may want to check these links http://aaron-hoffman.blogspot.com.au/2013/04/microsoft-excel-2013-sort-pivot-table.html http://www.pcreview.co.uk/threads/sort-calculated-field-in-a-pivot-table-an-example.971993/ Thanks