H HanSam Member Jul 12, 2017 #1 hi all, Is there a way where in when I filter a PT using a slicer, the source data where the PT is getting data is filtered as well? Thanks
hi all, Is there a way where in when I filter a PT using a slicer, the source data where the PT is getting data is filtered as well? Thanks
N NARAYANK991 Excel Ninja Jul 12, 2017 #2 Hi , It may be possible using VBA , but what would be the objective ? A pivot table is created as a summary of the source data ; with a pivot table created , why would you want to now look at the source data ? Narayan
Hi , It may be possible using VBA , but what would be the objective ? A pivot table is created as a summary of the source data ; with a pivot table created , why would you want to now look at the source data ? Narayan
H HanSam Member Jul 12, 2017 #3 for reporting purposes since all the data can't be seen by all recipients.
