Hi all,
I'm trying to get several pivot tables referencing a cell that itself is within a pivot table currently operated by a slicer and the reference would remain the same in this case $O$5. Unfortunately my data if from different sources so I can't link my pivot tables to a single slicer to perform the function. Ideally I would like to retain use of the slicer function to allow me to switch between product codes easily. My current slicer is working from a main table of complete product codes and the remaining ones are shorter in length and may omit product codes as there is no data against them.
Ideally I would like to be able to get the whole sheet to reference the pivot table the slicer is attached to immediately filter the other pivot tables on the same value. I've done some research and it seems that it could be done with VB saved in the sheets view code on the sheet tab. I've found some cases of people trying to reach something similar but nothing quite as specific as to what I'm after. I would like to retain the use of the slicer ideally. Also any ideas on what would happen to a code that's within the main table but not in the other tables and if blanks would be selected for the other pivots would be interesting to hear as it's part of a dashboard I'm putting together so if other codes remain in the pivots essentially not in use could be misleading.
Any help or advice would be much appreciated.
Kind Regards,
Haydn
Bookmarks