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...
 

Forum statistics

Threads
1,226,837
Messages
6,193,257
Members
453,784
Latest member
Chandni

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