| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table + Microsoft Query + Current Month
I automate most of my reports using pivot tabes... I use multiple criteria in
the backend such as =date() -1, like f*, etc... Anyways, is there a function I can place in crerita to give me current month... I would like to make my pivots a bit more dynamic.. Source data is either SQL Server 2005 or Access Databases... I know I can do it on database end when creating the views/queries however I would like to see if I can do it at the Excel end as well.. I appreciate the help Ramon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Microsoft Query & Pivot table? | Excel Discussion (Misc queries) | |||
| Selecting the current month using a macro on a pivot table | Excel Discussion (Misc queries) | |||
| Creating Date Range in Pivot Microsoft Query | Excel Discussion (Misc queries) | |||
| Current Month Query | Excel Worksheet Functions | |||
| Using Microsoft Query data in a pivot table. | Charts and Charting in Excel | |||
Threaded Mode
