Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table rolling 12 month filter?
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 conditional filters like 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. I'm using excel 2007. Thanks for any help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table rolling 12 month filter?
Randy,
I would think that you could form your query to only return 12 months of data - I don't use data cubes, so I'm just making an educated guess. Or you could group your data in your pivot table by date and set the start date for grouping as 6 or 12 months ago... HTH, Bernie MS Excel MVP "Randy Suggs" wrote in message ... 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 conditional filters like 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. I'm using excel 2007. Thanks for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rolling 12 month date filter for pivot table? | Excel Worksheet Functions | |||
Rolling Forward Pivot Table Source Data | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
How do I set up 12-month rolling month cells in excel? | Excel Discussion (Misc queries) |