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.
 

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

auto filter data within pivot table 1
Export Pivot table 1
Pivot table report invalid 0
pivot table filters 1
Adding Report Filters to Excel Pivot Tables via VB. 1
How to base a pivot table on another pivot table? 3
PIVOT - Reference a cell outside the table for report filtering 2
Auto filter and Pivot Table 1

Top