Pivot table not sorting correctly

I want to sort numbers in ascending sort order, Smallest to Largest. This is not sorting correctly.   For example, I right click in a cell in the Totals column of a pivot table and select sort – Smallest to largest.  But the total is not sorting in correctly.

What could be the cause?

 

Question Info


Last updated October 9, 2018 Views 29,798 Applies to:
Answer

Hi,

 

Try this

 

1. Go to the Filter drop down of Status and under More Sort Options, select Descending > Sum of Quantity

2. Go to the Filter drop down of Employee Code and under More Sort Options, select Descending > Sum of Quantity

 

You will now get your Total column numbers in descending order.

 

Hope this helps.

Regards,

Ashish Mathur
www.ashishmathur.com
http://twitter.com/excelashish

13 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Answer

Hi,

take a look here...http://youtu.be/d4a380WIzow

 

 

-----------------------------
Office 365 on Windows 10

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.