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 turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

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,775
Messages
5,574,159
Members
412,574
Latest member
shadowfighter666
Top