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

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

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,138
Messages
5,570,394
Members
412,321
Latest member
Yusuf_A
Top