How To: Page Fields
Pivot tables don't work that way. So there is no command to do that. Items
are either selected or they aren't, but they are all displayed. Possibly you could determine which should be available and select them, unselecting the remainder. -- Regards, Tom Ogilvy "Kevin McCartney" wrote in message ... With a Pivot Table how do I set up a relationship between Page Fields, in that if I select an item from the first Page Field the Pivot Table will reduce the contents of the second and subsequent page fields to only show items that relate to the selected item in the first Page Field, is essence the first Page Field acts as a filter on the other Page Fields. Any help much appreciated, thanks ciao KM |
All times are GMT +1. The time now is 02:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com