October 19, 2023
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.
January 31, 2022