The sales data contains the transaction information, which is often referred to as a fact table. These data sets could be on separate worksheets, but for ease of demonstration, I have included them on one. In our example file, we have three sections of data: Then you’ll be able to work along with examples and see the solution in action, plus the file will be useful for future reference.ĭownload the file: 0040 Combining multiple tables in a PivotTable.zip I recommend you download the example file for this post. The ability to create relationships has been around since Excel 2013, yet many users don’t even know this feature exists. For this post, we are focusing on creating relationships. Check out my Power Query series to understand how to do this. We don’t need to copy and paste data into another worksheet either as we can now use Power Query to import the data. Instead, we can build relationships that combine multiple tables and automatically create the lookups for us. But we don’t need to do all those VLOOKUPs anymore. ![]() ![]() After that, the data is ready, we can create a PivotTable, and the analysis can start. When most people use PivotTables, they copy the source data into a worksheet, then carry out a lot of VLOOKUPs to get the categorization columns into the data set.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |