Pivot Table - Macro to Change Field Vlaue

[Meedan]

Hi,


I have a pivot table with huge data in it. Beside Pivot Table I have inserted a Combo box dropdown having number 1 till 5.


Now I need if I select 1 in this dropdown, in pivot table - Values - 10 Column should be inserted in Pivot table.

if 2 then 7 different Columns & rest should be removed.

If 3 then x different Columns & rest should be removed.

If 4 then x different columns & rest should be removed.

If 5 then X different columns & rest should be removed.

(Altogether I have more than 50 columns in data.)

Basically, depending upon the number in combo box, my Pivot table Values should change.


I can modify macro as per my column name, you can use "A - Z" instead of Column name.


Please assist

 

[Meedan]

If possiblem, also all the columns that would be updated/changed in Pivot should calculate as Average.


(When we insert any column any Pivot table - Value, it shows Count.)