| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get running 12 months of data using date filter?
I am using Excel 2007 connected to a SQL DB and use pivot tables for
reporting purposes. I have multiple years worth of data that I access, but want to limit my pivot table to display just the last 12 months. I can't seem to find a way to do this, but am sure someone must have solved this problem already. I consider myself pretty Excel savvy, but I'm no programmer so hold the VB please. Thansk! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3 months prior and 3 months post a date | Excel Worksheet Functions | |||
| filter data by date | Excel Discussion (Misc queries) | |||
| Filter date time data | Excel Discussion (Misc queries) | |||
| Running total of last 6 months in rows | Excel Discussion (Misc queries) | |||
| Fiscal year total from running 12 months | Excel Worksheet Functions | |||
Threaded Mode
