This project has moved. For the latest updates, please go here.

how to remove a page field from a pivot table

Jul 7, 2011 at 10:33 AM

Hi

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.

Thanks,

Chandrasekhar.S