Repeat for all three tables.Īfter creating a table, Excel uses names like Table1, Table2, and Table3. Make sure My Table Has Headers is checked in the Create Table dialog box. Select one cell in a data set and press Ctrl+T to create a table. Next, convert the original data sets and your new small table of sectors into a table. You might use an Advanced Filter for this, but an easy way is to copy the Sector column from both data sets to a new table and then use Data, Remove Duplicates to make sure each industry appears in the list just once. Your first step is to create a new table that has a sorted, unique list of the industries found in either report. Both data sets have a Sector field listing the industry sector.īecause this technique uses the Data Model, it only works in Windows versions of Excel. The goal is to have a slicer that can filter all the pivot tables by industry. You want to summarize both data sets in a dashboard. For this example, you have a sales worksheet and a quality worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |