PDA

View Full Version : filter pivot tables with one pivot table with multiple value selection



tommy1234
05-05-2014, 11:30 AM
hello
i have 4 pivot table in hidden excel worksheet.
i want to create one pivot table in the visible worksheet in which i would be able to select multiple values which will cause the other pivot table to be filter according to the values i selected.

thanks

Bob Phillips
05-05-2014, 03:59 PM
Not sure I fully get it, but why? If it is hidden who cares how it is filtered?

tommy1234
05-07-2014, 11:29 PM
i have one visible sheet with one pivot table.
i want to select multiple values in the visible pivot table and after that a vba code will run in the backgrpund and will filter all the hidden pivot tables with the selected values.

Bob Phillips
05-08-2014, 01:40 AM
I am sure I could do it by checking the field status but I again ask, what is the point of creating hidden pivot tables?