HI Guys , I am trying to do a pivot table , can anyone please help .
I am a self learner , I am trying this
I have the data from 3 tables , CPR Table , DPR Table and STOCK Table …
CPR - supplier table
DPR is customer table …
I just trying to do …what product from supplier has been bought by - which customer
and at what price and when contract end for both supplier and customer. I have expected result attached and file attached . Thanks in advance
testdpr-cpr.xlsx (271.1 KB)