Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Data - Troubleshoot needed | Excel Discussion (Misc queries) | |||
Pivot table formats text data with 2 decimals | Excel Discussion (Misc queries) | |||
Can I set a filter on the source data for a pivot table | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Pivot table and filter | New Users to Excel |