I am very new to power pivot and I am only scratching the surface of what I think it is capable of. I have created a query that shows stock levels by part number and another that shows delivery schedule qty for each part by week number. Both work well as individual pivot tables, I am trying to combine both queries in Power Pivot so that I can see stock level and when parts are due to be delivered to top up stock. No matter what I try I can only manage to display total to be delivered by part.
Any help gratefully received
Any help gratefully received