Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Please assist
I have the following code to remove the field subtotals except for 2 from pivot: for Each pf In ActiveSheet.PivotTables("PivotTable2").PivotFields If pf.Name = "field1" Or pf.Name = "field2" Then Exit For pf.Subtotals = Array(False, False, False, False, False, False, False, False, False, False, False, False) Next This code removes all subtotals; however, I want subtotals of the first 2 fields. Thanks Gwen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why are some subtotals missing from my pivottable? | Excel Discussion (Misc queries) | |||
Using a field name in an IF function for a calculated field in a PivotTable | Excel Worksheet Functions | |||
PivotTable Automatic Subtotals | Excel Discussion (Misc queries) | |||
PivotTable - PivotTable Field name is not valid - error! | Excel Programming | |||
Help! Turning off PivotTable Subtotals | Excel Programming |