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

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

Still not sure how to use power query to get the two column data , pls show steps further.

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

Thanks so much Mynda continued follow-up my case, will try hard to learn this.