| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rolling 12 month date filter for pivot table?
Is there a way to add a rolling 12 month date filter for 'last 12 months' to
a pivot table? I see how to add last year, last month, etc., but I need a way to filter for last 12 months (or even last 6) so that I don't have to update the date filter every month. This pivot table is for manufacturing production data and is connected to an analysis services data cube. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date filter in a pivot table | Excel Discussion (Misc queries) | |||
| XL2007: Pivot table date filter | Excel Discussion (Misc queries) | |||
| Problem Converting date to month in text for use in pivot table | Excel Worksheet Functions | |||
| Convert date field to month in Pivot table | Excel Discussion (Misc queries) | |||
| how to change date formating-grouped by month in pivot table | Excel Discussion (Misc queries) | |||
Threaded Mode
