Myriad_Rocker
Board Regular
- Joined
- Dec 1, 2004
- Messages
- 67
So this is super frustrating...
I have a pivot table with three data fields (columns). Just to the right of that are five columns that I calculate using formulas.
When I execute this: ActiveSheet.PivotTables("PVT_Comparison").DataPivotField.Orientation = xlHidden
The freakin' thing wipes out six total columns. The three data fields (good to hide) and then my three formula columns to the right (but leaves the last 2 formula columns untouched).
Is there some sort of number I need to change that tells the pivot how many data fields are there? I don't get why this is happening!
Hopefully someone can help.
FYI: The pivot used to be six data fields (columns) wide. I had to take three out and make them formula columns. The reasons for that are multi-dimensional, trust me. It was a MUST scenario.
I have a pivot table with three data fields (columns). Just to the right of that are five columns that I calculate using formulas.
When I execute this: ActiveSheet.PivotTables("PVT_Comparison").DataPivotField.Orientation = xlHidden
The freakin' thing wipes out six total columns. The three data fields (good to hide) and then my three formula columns to the right (but leaves the last 2 formula columns untouched).
Is there some sort of number I need to change that tells the pivot how many data fields are there? I don't get why this is happening!
Hopefully someone can help.
FYI: The pivot used to be six data fields (columns) wide. I had to take three out and make them formula columns. The reasons for that are multi-dimensional, trust me. It was a MUST scenario.
