Sort function on Pivot Table

D

Dinesh

Does anyone knows why Pivot table do not sort properly if your sort is based
on 2.3.or 4... column. I have tried many times and always resort to 1st
Column. I have also tried the Advance function of Pivot Field.

Thank
Dinesh
 
J

Joe Mac

Hey Dinesh...

Look at the Options tab on the Data Sort pop up window... if it is set to
"Sort left to right" it will default to the first column in the Pivot
Table... otherwise select the "Sort top to bottom" option for the pivot
table to sort on the column that you have selected...
 
D

Dinesh

Hi Joe,
It is set to "Top to Bottom". Although, the orientation do not give you an
option to change it on Pivot table. It's default to Col "A.

Thanks.

Dinesh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top