Need help to use Two Slicer for filtering pivot Table

spycein

Board Regular
Joined
Mar 8, 2014
Messages
135
Office Version
  1. 365
Platform
  1. Windows
Hi Everyone... Need your help again.. I have two pivot tables and i have created two slicers and connected with both the pivot table..

PivotTable1:-
Filter
Month
Invoice No.

Rows Column
Dates Values

PivotTable2:-
Filter
Month
Invoice No.

Rows Column
Dates spot Counts

And the slicers are:-

Slicer 1 Name:- Invoice No. and Slicer 2 Name:-Month

Now if select the invoice no. in the slicer 1 the both the pivot table shows the invoices for the overall month and if i select the month in the slicer 2 then both pivot report show month wise value.

What i want is to get the pivot report month & invoice wise. For example if invoice no.1 is entered in April 2014, Invoice No.2 & invoice 3 are entered in May 2014 and if select May in the slicer 2 then in both the pivot report invoice 2 & 3 should be shown.And if i select April then Invoice no.1 should be shown only.

Hope you understand my query...

Again thank you so much for your help...
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Forum statistics

Threads
1,216,765
Messages
6,132,586
Members
449,737
Latest member
naes

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top