Hi Srinidhi ,the pivot table wizard has a limitation that data type of both the tables should be same hence ,I am facing some issue.I will paste snapshot of the two files I have
Basepack Distribution Channel Customer State MoC Month Total Tons
19336 GT Haryana...
Hi Team,
I have two files having a prodct code ,its plan for a week ,and the factory it is made in .second sheet has customer state and sales per month of dose product code .I want to create a pivot having details of coloumn where it is made how much it is made and whre all it is sold,and how...