I have two very simple tables:
1. sales
month - product - sales
jan.15 - smth1 - 55
jan.15 - smth2 - 50
feb.15 - smth1 - 5
2. budget
month - product - budget
jan.15 - smth1 - 60
jan.15 - smth2 - 67
Both tables inputed to data models. Products are linked, but still in a pivot table values from one table are not linking to another and i get the following:
month - sales - budget
jan.15 - 105 - 127
feb.15 - 5 - 127
By all means the data model should be working correctly with a such simple example, but it still does not work.
Has anyone had whis problem? WHat could be the solution? Seem like the powerpivot just has a bug or error.
1. sales
month - product - sales
jan.15 - smth1 - 55
jan.15 - smth2 - 50
feb.15 - smth1 - 5
2. budget
month - product - budget
jan.15 - smth1 - 60
jan.15 - smth2 - 67
Both tables inputed to data models. Products are linked, but still in a pivot table values from one table are not linking to another and i get the following:
month - sales - budget
jan.15 - 105 - 127
feb.15 - 5 - 127
By all means the data model should be working correctly with a such simple example, but it still does not work.
Has anyone had whis problem? WHat could be the solution? Seem like the powerpivot just has a bug or error.