Hi,
I just started Powerpivot a month ago and I'm not sure if this can be easily solved but I'm kind of stuck on this relationship creating section...
I have 4 tables. Table 1 (Supplier Forecast) is the supplier forecast, table 2 (Lift Actual) is the Actual Data of Month, table 3 (BU Forecast) is a Business Unit Forecast and Table 4 (Region Sort) is a unique value table to sort Table 1 and 2.
"Region Sort" contains all the unique region names (for example: Canada, US, Africa). Table 1 and Table 2 both have columns with these region names repeated several times for each row. That's why I created this table so Table 1 and Table 2 can relate to it such that I can create a pivot chart with a slicer to filter both tables. This way I can filter the sums of volume for both tables to create a comparison chart.
Now I want to link "BU Forecast", which has the region column and a business unit column (commercial, wholesale, retail) to these set of data such that I can create a slicer to filter the business unit, which would then automatically filter "Region Sort", which would then affect table 1 and 2. Sometimes, 1 region can have mutiple business units, and vice versa...
So overall, the problem is to create a slicer based on Business Unit, such that it can be filtered to affect Region names (table 3) to affect table 1 and 2.
Thanks in advance for reading the long post! Hard to explain :/
I just started Powerpivot a month ago and I'm not sure if this can be easily solved but I'm kind of stuck on this relationship creating section...
I have 4 tables. Table 1 (Supplier Forecast) is the supplier forecast, table 2 (Lift Actual) is the Actual Data of Month, table 3 (BU Forecast) is a Business Unit Forecast and Table 4 (Region Sort) is a unique value table to sort Table 1 and 2.
"Region Sort" contains all the unique region names (for example: Canada, US, Africa). Table 1 and Table 2 both have columns with these region names repeated several times for each row. That's why I created this table so Table 1 and Table 2 can relate to it such that I can create a pivot chart with a slicer to filter both tables. This way I can filter the sums of volume for both tables to create a comparison chart.
Now I want to link "BU Forecast", which has the region column and a business unit column (commercial, wholesale, retail) to these set of data such that I can create a slicer to filter the business unit, which would then automatically filter "Region Sort", which would then affect table 1 and 2. Sometimes, 1 region can have mutiple business units, and vice versa...
So overall, the problem is to create a slicer based on Business Unit, such that it can be filtered to affect Region names (table 3) to affect table 1 and 2.
Thanks in advance for reading the long post! Hard to explain :/
