| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.sqlserver.olap
|
|||
|
|||
programmatically change pivot table rows/columns
Hi all,
I have a Pivot table that is built on an OLAP cube. I would like to be able to pop up a dialog (in Excel) and ask the user to select a date range. Then, using this date range, programmatically change the [Time] dimension in my pivot table so that only this range is displayed. Anybody has any idea how this can be done? Thanks, L |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows to columns in a table or pivot table | Excel Discussion (Misc queries) | |||
| Too many rows or columns in pivot table | Excel Discussion (Misc queries) | |||
| Too many rows or columns in my pivot-table | Excel Discussion (Misc queries) | |||
| programmatically fix no. of rows and columns | Excel Programming | |||
| change a table to 3 columns only (Rows instead of Table) | Excel Programming | |||
Linear Mode
