Newbie Question - Combining tables

[Javlin7]

Sorry if this is a silly question. I'm new to Power Pivot, am working though Rob Collies book, but I'm also trying to solves some issues while I'm at it.

I have a problem which I'm sure is a simple one to solve, I just can't work it out.

I have created a power pivot with the following tables

Opening Stock
Production
Despatches

Each row in the tables have a unique production event ID called "CAST"


The problem I have is showing the three tables as a sensible pivot...
There are cast ID's in opening stock that don't appear in the production table
The Production Table contains all new CAST id's (ie they don't exist in the opening stock table)
Despatches table contains a mix of Opening stock Cast ID's and Production Cast ID's

My pivot table ends up showing values by Cast for the production table, but only a total against a blank cast for the other two tables.....

How can I make the pivot show all the casts ie 1-100 as opposed to only showing say 35-100 ?

Thanks
Mike

 

[greg kramer]

Hey Mike.

If you're working through Rob's book, it seems to me, you are now starting on "Thinking in Multiple Tables" p 75.

This an an introduction to dimensional modeling which sounds a lot harder than what it is. In short to do things the Power Pivot way you need to have dimension tables and a fact table(s). Looking at your tables it is not immediately clear which is which.

If you want to continue giving examples from Rob's book that would be good or if you want to work me on some of these ideas for free schedule a 1/2 hour meeting with to discuss. I would welcome the chance to see how effective I am in conveying these ideas to others. Please book me here, https://www.sohelpful.me/gregorykramer

Thanks.