Multiple Pivot Tables with single Page Field
 

I've got two pivot tables on a sheet, one showing the selected week's
totals, and the other showing the month's totals. I want to link these
two tables to update automatically--if someone selects the week of
4/24/2005, then I want the other table to automatically select April
2005. What's the trick to doing this?

thanks!
Craig


--
cscribner
------------------------------------------------------------------------
cscribner's Profile: http://www.excelforum.com/member.php...o&userid=23661
View this thread: http://www.excelforum.com/showthread...hreadid=374094

You can do this with programming. There's a sample file he

http://www.contextures.com/excelfiles.html

Under Pivot Tables, look for 'Change Page Field'

cscribner wrote:
I've got two pivot tables on a sheet, one showing the selected week's
totals, and the other showing the month's totals. I want to link these
two tables to update automatically--if someone selects the week of
4/24/2005, then I want the other table to automatically select April
2005. What's the trick to doing this?

thanks!
Craig




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html