Hi,
I have a pivot table that has some code in it so the end user can select specific weeks of sales data they want to see. I want to put a heading on my pivot table report which then displays this range. Ie: if someone has asked to see sales data for weeks 3 to 6, within the Page field cell it says (multiple items) - I want to then have within a cell above the pivot table a heading along the lines of "Sales for weeks 3 to 6". Is there some code out there that can do this?
Or how do I link another pivot table to display the min and max of my main tables page fields which I can them simply reference for my heading?
Many thanks in advance.
Gerry
I have a pivot table that has some code in it so the end user can select specific weeks of sales data they want to see. I want to put a heading on my pivot table report which then displays this range. Ie: if someone has asked to see sales data for weeks 3 to 6, within the Page field cell it says (multiple items) - I want to then have within a cell above the pivot table a heading along the lines of "Sales for weeks 3 to 6". Is there some code out there that can do this?
Or how do I link another pivot table to display the min and max of my main tables page fields which I can them simply reference for my heading?
Many thanks in advance.
Gerry