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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

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,118,813
Messages
5,574,483
Members
412,596
Latest member
nickthebizz
Top