Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default auto filter data within pivot table

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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default auto filter data within pivot table

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

" wrote:

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Data - Troubleshoot needed aly1cat Excel Discussion (Misc queries) 4 August 4th 06 10:18 PM
Pivot table formats text data with 2 decimals Don S Excel Discussion (Misc queries) 3 October 6th 05 12:45 AM
Can I set a filter on the source data for a pivot table ChrisP Excel Discussion (Misc queries) 2 August 29th 05 09:56 PM
Pivot Table for survey data w/ questions as Rows & poss answrs as pfwebadmin Excel Discussion (Misc queries) 0 May 17th 05 02:31 PM
Pivot table and filter Bruce Roberson New Users to Excel 1 January 25th 05 04:00 AM


All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"