G
GeraldS
Hi,
I have a pivot table that has some code (taken from another spreadsheet) in
it so the end user can select specific weeks of sales data via the page
field. 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 out
of a total of 52 weeks data, the Page field cell will display "(multiple
items)" - I want to have within a cell above the pivot table a heading along
the lines of "Sales for weeks 3 to 6" which would automatically change
depending on what is in the pagefield. Is there some code out there that can
do this? Can getpivotdata display the min and max of the pagefields?
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 (taken from another spreadsheet) in
it so the end user can select specific weeks of sales data via the page
field. 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 out
of a total of 52 weeks data, the Page field cell will display "(multiple
items)" - I want to have within a cell above the pivot table a heading along
the lines of "Sales for weeks 3 to 6" which would automatically change
depending on what is in the pagefield. Is there some code out there that can
do this? Can getpivotdata display the min and max of the pagefields?
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