Need help to create a Pivot Table using Powerpivot|Power Pivot|Excel Forum|My Online Training Hub

Hello, 

I'm fairly new to PowerPivot I've only created one before but that was fairly simple so wasn't too difficult. The pivot table that I am trying to create now is a lot more difficult. I did think I needed to use some form of DAX formula and tried to create some formulas but to be honest I know nothing about DAX I was just trying something that someone has suggested. I did post a question on the Microsoft Community this is the link https://answers.microsoft.com/.....359b7b6bdb but didn't quite get the answer I was looking for. 

The issue I have is that I have 3 different tables that I would like to combine using different sections from each table. The common link between the tables is an order number, however in 2 of the tables the order number is repeated. I have attached a my spreadsheet. I have added 2 tabs (1 additional one from when I posted on Microsoft community) to given examples of what I would like my pivot tables to look like. 

Any help would be greatly appreciated as I am totally over my head.

Many thanks