HOW TO SORT A PIVOT TABLE

A

Alex

How to automatically make that the pivot tables sorts data by itself. Every
time a change one value it mixes up my figures....
 
B

BrianB

Right click in the field to be sorted to get a menu
Click Field
Click Advanced
Choose the sort option.


Regards
BrianB
=============================================
 
A

Alex

THANK YOU VERY VERY MUCH


BrianB said:
Right click in the field to be sorted to get a menu
Click Field
Click Advanced
Choose the sort option.


Regards
BrianB
=============================================



"Alex" <[email protected]> wrote in message
Click to expand...
 

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

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Pivot table report invalid 0
Power Pivot. Yikes. 0
Pivot Table cell values 1
SUM & OFFSET & PIVOT TABLE?? 0
Sorting Ascending Subgroup in a Pivot Tables - 2007 0
pivot 0
Pivot Tables in Excel 2007 vs 2003 1

Top