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 |