Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PIvotitems visible
I have Dept, Gender, and Qty fields in a PT. I can make visible the Dept
pivotitems that i chose, but am unable to then loop through the correct remaining Gender pivotitems within that dept. Unable to get the correct 'count' nor identify the Gender items that are specific to that dept. My goal is to create one master PT for the entire dept, and then create individual PTs underneath for each individual Dept/Gender. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Controlling Pivotitems.visible | Excel Discussion (Misc queries) | |||
Setting Many PivotItems' Visible property to False | Excel Programming | |||
Error 1004 with PivotItems.Visible | Excel Programming | |||
Visible PivotItems matching criteria | Excel Programming | |||
Always keep the same 4 PivotItems visible | Excel Programming |