Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot tables
how can I ask for data within a certain date range in a pivot table?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot tables
Hi
It all depends exactly what you are trying to do. If Date is a Row field, you could click on the dropdown for the field, untick Show All, which deselects all of the dates, then just put a check mark against the individual dates you want to see. You could right click on the Date field heading, and choose Group & OutlineGroupMonths or Years and MonthsOK You will then see the dates summarised by Month, or by Year and Month, and use the dropdown to select the month you want. If you need more help, post back, and also say which version of Excel you are using. -- Regards Roger Govier "CMIConnie" wrote in message ... how can I ask for data within a certain date range in a pivot table? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
build a pivot table from multiple other pivot tables. | Excel Discussion (Misc queries) | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |