I have a pivot table. I want the users custom the stucture of the table. I draw 4 tables like below.
These tables have 4 dimensions and 1 expression.
Tab1 has all dimensions and expression on the top.
Tab2 has 2 dimensions(Year and YearMonth) on the top and 1 denmension in the "left".
Tab3 has 1 on the top and 2 in the left.
I want to change the pivot into these different structures with MACRO. And I know a property named cp.TableProperties.NumberOfLeftDimensions can control Number Of Left Dimensions. I can get tab1(set NumberOfLeftDimensions=0) and tab4 (set NumberOfLeftDimensions=3). But I don't know how to get tab2 and tab3. I think if there is some other property which can help me to solve the problem?