Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Selection of Pivottable Drop Down Items
Hello,
I have a pivottable report that is generated from an OLAP cube. One of the elements of the table is a Date field. For this report, I want to automatically select the Last 6 months from the drop down menu (based on current date) when the spreadsheet is opened. For example, I have the date item on columns. Since it's november, I want to automatically select June, July, August, September, October, November for the initial display. I have seen this done on pivottables based off of dynamic range data, but have not been able to find anything on OLAP based pivottables. Does anybody have any ideas on if/how this would work? Thanks in advance for any help! ph *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down - Multiple Items Selection | Excel Discussion (Misc queries) | |||
Displaying Drop down list items based on selection of another colu | Excel Discussion (Misc queries) | |||
Dynamic drop-down lists based on an initial value selection | Excel Discussion (Misc queries) | |||
PivotTable: Difference from Row Items | Excel Discussion (Misc queries) | |||
PivotTable - calculated items? | Excel Discussion (Misc queries) |