To generate the first one, do the following: Click anywhere inside the Table (the demonstration files sheet name is Multiple PivotTable Table).Ĭlick the Insert tab and then choose Recommended PivotTables in the Tables group. If youre using Excel 2016, Excel does almost everything for you. Well format the PivotTables and sheet to resemble a dashboard environment (sort of).
Well copy the first PivotTable to create a second PivotTable.
It might be helpful to know what to expect: Well create the first PivotTable. The second PivotTable wont even display the region, but the slicer will still filter it by region.Īlthough the entire process is simple to implement, there are several steps. The first PivotTable will sum the Value field by region the second will sum the Commission field by personnel. This file also contains the example data and slicer from last months article.) SEE: Microsoft releases 64-bit Office for Mac: The secret to getting it A quick preview Well be working with the data shown in Figure A to create two PivotTables and then link the same slicer to both. This month, well continue our discussion of slicers with a more advanced topic: using a single slicer to update two or more PivotTables.ĭoing so is helpful when you want to focus on data in the same data source in different ways.įor your convenience, you can download the.xlsx demonstration file. This graphic tool lets users, with no specialized skill, filter data in a meaningful way.
0 kommentar(er)
