Forum

Need help to create...
 
Notifications
Clear all

Need help to create a Pivot Table using Powerpivot

3 Posts
2 Users
0 Reactions
167 Views
(@tatie_13)
Posts: 5
Active Member
Topic starter
 

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/en-us/profile/b4ff65ef-e16a-4fb8-adbd-5d359b7b6bdb 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 

 
Posted : 20/10/2023 11:18 am
Riny van Eekelen
(@riny)
Posts: 1195
Member Moderator
 

Please try uploading the file again. This time, press 'Start Upload' and wait until it's done before you submit your reply.

 
Posted : 20/10/2023 11:34 am
(@tatie_13)
Posts: 5
Active Member
Topic starter
 

Apologies I thought that I had done this. I've redone it and the status says 100% size 795kb.

Many thanks for your help

 
Posted : 21/10/2023 2:47 am
Share: