How Do I Sort a Pivot Table on Grand Total with Multiple Columns?

Topic

New Reply

My “Pivot Table” (model attached) has many columns of data. I had to blank out some fields due to sensitive nature of data. Either way, I think you can see my gist. I am looking to sort in descending order based on the Grand Total column. How to do this?

Many Thanks!

Mitch

Reply | Quote

Replies

You need to sort the plant field using the values data. Right-click the plant field, Sort – More sort options)

Reply | Quote

I tried. I don’t think this will work or can you add more detailed info on how to execute this?

Reply | Quote

As I said – right-click the Plant field, choose Sort, then ‘more sort options’ and choose to sort using the value field.

Reply | Quote

My “Pivot Table” … sort in descending order based on the Grand Total column. How to do this?

Click in the GT column.
Click Home tab, Editing section [far right], click the Sort Arrow, Click on the Z-A choice.

Are you sure that’s a pivot table, doesn’t look like my usuals. However, above works for a normal table too.

Lugh.
~
Alienware Aurora R6; Win10 Home x64 1803; Office 365 x32
i7-7700; GeForce GTX 1060; 16GB DDR4 2400; 1TB SSD, 256GB SSD, 4TB HD

Reply | Quote