auto filter data within pivot table

  • Thread starter Thread starter elaine
  • Start date Start date
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.
 
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
Auto filter and Pivot Table 1
Pivot Table w/ Access data 3
PIVOT - Reference a cell outside the table for report filtering 2

Back
Top