Enable/disable expressions in pivot table

[#1]

I have 7 different expressions that need to be available in a pivot table - problem is not all 7 need to be used everytime, and any combination of the 7 could possibly be needed at anytime.

What's the easiest/best way to give the end users the flexibilty to select the expressions that are shown in the pivot table?

[#2]

Hi,

Herewith i have attached an example for your reference. Pls find the macro.

Go to Document Properties ->Trigger Tab--> and find under the field trigger.

Regards

Rajesh