auto filter data within pivot table

E

elaine216

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???

It doesnt seems to work?!

Thanks.
Elaine.
 
G

Guest

hi, you can filter data as normal - just click on the down arrow and select
from the list. you can also sort the data by sitting in a cell of the
column you want sorted and selecting data sort - this brings up a box and
just click on ok.

hope this helps
deb
 

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
Sorting Pivot Table by Total 1
Pivot Table Refresh 1
Sort choices in filter in pivot table 1
date filter in a pivot table 1
pivot table data 2
Pivot Table Sort Order 1
Data Lookup Question 1

Top