Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table calculated field in data area
Hi,
I am having an issue with a calculated field. By using a checkbox , I pull a calculated fied into the data area and when unchecked , I want to hide the calculatedfield out of the data area. My main difficulty is during the uncheck..Iam using the following stmt. It doesn't seem to work. I would appreciate if someone can tell me how I can do this. THe statements below work well with a standard field but not with a calculated field. thanks Kanan Here is the stmt I use to drag the field to the data area: ActiveSheet.PivotTables("PivotTable2").AddDataFiel d ActiveSheet.PivotTables("PivotTable2").PivotFields (Fieldname), " " + Fieldname, xlSum the statement to hide the calculated field from the data area is: ActiveSheet.PivotTables("PivotTable2").PivotFields (Fieldname).Orientation = xlHidden |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table, IF function, calculated item versus calculated field | Excel Discussion (Misc queries) | |||
Pivot - Calculated field in row area | Excel Discussion (Misc queries) | |||
Calculated Field in Pivot Table Based On Totals-and hide a data fi | Excel Discussion (Misc queries) | |||
Possible 'calculated field' to total selected pivot table data ite | Excel Discussion (Misc queries) | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) |