Hello there;
i have a pivot table with one variable on rows and one on column (this one represent month).

Now i want to display only the last 3 monthes from a value in a cell on the same sheet.
I want to do it with vba, because when the cell changes the row labels of the pivot table should automatically adjust to display the last 3 monthes.

I have the values of the last 3 monthes in vba within one array. this is the easy part.
now i would like to know how to have a procedure that takes thos 3 monthes and only allow them to be visible in the pv, (the rest should be invisible).

can someone help me please,
thanks a lot