Slicer connecting pivot and associated table

krishna334

Active Member
Joined
May 22, 2009
Messages
391
Hi All,

I have a table called "Data" in my worksheet.
I have created a pivot using this table and have inserted a slicer.

Now, when i select the values in the slicer, the pivot value also changes.
But is it possible that the Table "Data" also gets filtered on making selections in the slicer.

Thank you in advance.
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

krishna334

Active Member
Joined
May 22, 2009
Messages
391
Hi Worf,

Thank you for the link.
This will definitely help.

Regards

Krishna Kumar
 

Watch MrExcel Video

Forum statistics

Threads
1,112,816
Messages
5,542,660
Members
410,567
Latest member
SCraig123
Top