We will insert a slicer for one first PivotTable as of now. We need to analyze month-wise for both the PivotTables. For example, see the image below, where we have two PivotTables.įirst, the pivot table shows the report segment-wise, and the second table shows the report country-wise. We can apply the same slicer for two PivotTables. #3 How to Add Slicer for Two Pivot Tables Only “Government” and “Carretera” have been highlighted in the slicer. The PivotTable begins to show the report only for the applied filters. If you wish to filter out the report only for the segment “Government” and the product “Carretera,” you can select the options from the slicers. The report shows the summary of all the segments and all the products.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |