Dear All

I would appreciate help with the following problem:

I have Power Pivot which contains various tables. I have and have created a pivot report. What I need to do depending on what user want to see (they get a choice from a menu) the Power Pivot table to add or remove the appropriate Row Labels and measures.

I can add a measure using the code below:
Please Login or Register  to view this content.
Is there a way which I can write Vb code to add Row Labels and measures from different tables and also to be able to remove the existing Row Labels and Measures?

The code below doesn't work

Please Login or Register  to view this content.
which I presume it will not work as this is for normal pivot.

Any help is appreciate it



Any help is appreciate it