auto filter data within pivot table

E

elaine

Hello,

Does anyone know how can we filter data within a pivot table? or sort
the data from ascending to decending order withing a pivot table???
Can we do that?

It doesnt seems to work?!


Thanks.
Elaine.
 
D

Debra Dalgleish

You can add fields to the page area, and use them to filter the pivot
table's data.

To sort a field, select a cell in a column, and click the A-Z button on
the Excel toolbar.
 
Top