5 Replies Latest reply: May 9, 2012 9:52 AM by Ravi Kumar RSS

    Dimension field change in PivotTable with macro

    Peyman Azimabadi

      Hi all,

      i have a pivottable, and it has two dimensions. i need two change the field defined in second dimension. I know that it's possible to use RemoveDimension and then AddDimension, but for some reasons i need to keep the dimension and only change the field name in defination. Do you think that it is possible?

      i will appreciate any help.

       

      Best Regards

      Peyman