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