Log In
Register
Home
December 5, 2016
Offline
Per attached sample Pivot table, pls help how to incorporate columns into the Table ie to show the Variance and Shipping date
July 16, 2010
Offline
Hi David,
You first need to pivot your data, which I've done in the attached file using Power Query - see sheet called Query. Then you can create the PivotTable and add a Calculate Field - see sheet called Pivot based on Query.
Note: your 'Per Oracle values don't have the shipping date information, hence the two rows in the PivotTable. You'd need to fix the source data if you want these rows aligned in the PivotTable.
Mynda
December 5, 2016
Offline
Thanks so much the hints, Mynda.
But still need to know how to use Query to set two column data ie Per Oracle and ie Estimate column data and generate the Query worksheet ?
Pls help furhter
December 5, 2016
Offline
Still not sure how to use power query to get the two column data , pls show steps further.
July 16, 2010
Offline
Hi David,
Sorry for the slow reply.
If you edit the query in the file I attached you can see the steps I took. If you're completely new to Power Query then you might be best to take my Power Query course, where I cover this technique and many more.
Mynda
1 Guest(s)
