Can someone help me out with code to remove a page field from a pivot table. I need to add same field as a row field.
have tried 'pivottable.pagefields.remove(fld)' but it didnt work. field is still remains as page field and when i try to add the same field as row field system throws the below error.
"The field is already a page or column field.can's add as a row field."
your help is really appreciated.