Hopeless Cub Fan
New Member
- Joined
- May 25, 2011
- Messages
- 31
New to PowerPivot, so trying to figure out how to best use this awesome tool.
I have two reports, both of which have a number of fields in common, I am trying to merge the two different reports into one using Plant/CH3/Sold-To/Ship-To/Material Group as join criteria. I have attached a screen shot of my two reports in PowerPivot.
I also want to combine the “Quantity” field in my SOI report with the “Open Orders Qty” in the BI report. What is the best way to accomplish this?
I came across what looked like a good solution at Creating lookup tables in PowerPivot using SQL queries | Javier Guillén, but it seems I need to be connected to a SQL Server instance. Thanks in advance for your help!

I have two reports, both of which have a number of fields in common, I am trying to merge the two different reports into one using Plant/CH3/Sold-To/Ship-To/Material Group as join criteria. I have attached a screen shot of my two reports in PowerPivot.
I also want to combine the “Quantity” field in my SOI report with the “Open Orders Qty” in the BI report. What is the best way to accomplish this?
I came across what looked like a good solution at Creating lookup tables in PowerPivot using SQL queries | Javier Guillén, but it seems I need to be connected to a SQL Server instance. Thanks in advance for your help!
