Home |
Search |
Today's Posts |
#1
|
|||
|
|||
master select page field for many pivots in one work book
I am building massive pivot reports - many pivots on many sheets of a work
book. Is there a way to select a page field value in a pivot ( or other fields as well) and have all other pivots on the sheet, other sheets, and the entire workbook have there page filed set to this same value. This would allow me to deploy some fantastic tools to people. I am speaking of slect the customer(one fo my fields) in a single pivot - designated as the master pivot if thats easier - then have automated switch to that cusotmer in all other page fields. Thanks for the time |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
How do I select only specific parts of one field? | Excel Worksheet Functions | |||
Pivot Table Page Field | Excel Discussion (Misc queries) | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions |