You need to make a 3rd table with both data than make a pivot table out of it? Not if you have power pivot on your disposal. Sales table has item group data and customer table has city data. You want to see from which products are sold to which city. You can define relations between separate tables with one click and then create pivot tables that can use fields from all these tables at the same time, all thanks to power pivot.įor example, you keep a table to track sales and another one to track customer information. You porbably make a third table that contains necessary columns from both tables and make your analysis using that table. When you need to make analysis with the data from two of these tables, things gets messy. Most of the time you keep seperate data tables for different but related data sets. This post is a tutorial about making simple relational pivot tables. Important: This post is not explaining all aspects of power pivot and detailing all of it’s uses.
0 Comments
Leave a Reply. |