CrossTable(Week1,Value,9) [Capex Plan]: LOAD "Project List", Domain, "Budget From A7x", "Current Demand", "PO Released", "E-decision & PO under Progress", "RCT Approval", 'Plan' as Type1,
"Cash Out until Oct 23", W01, W02, W03, W04, W05, W06, W07, W08, W09, W10, W11, W12, W13 FROM [lib://source Path (techadmin)/ISIT/BUDGET/Capex Splitup 2.xlsx] (ooxml, embedded labels, header is 1 lines, table is [Capex Plan]);
CrossTable(Week1,Value,9) [Capex Actual]: LOAD "Project List", Domain, "Budget From A7x", "Current Demand", "PO Released", 'Actual' as Type1, "E-decision & PO under Progress", "RCT Approval", "Cash Out until Oct 23", W01, W02, W03, W04, W05, W06, W07, W08, W09, W10, W11, W12, W13 FROM [lib://source Path (techadmin)/ISIT/BUDGET/Capex Splitup 2.xlsx] (ooxml, embedded labels, header is 1 lines, table is [Capex Actual]);
How to work on this data I want to compare Plan vs actual by two excel sheets all fields are common I need to link this two table by type which is 'Plan' as Type & 'Actual' as Type'
Please guide me in this process I dont know how to proceed this
