[Forecast Lookup]: LOAD [Type], [Program Name], //[Project Name], [OpEx #], [CapEx #], [CC], [FL/Owner], [Project Sponsor], [Start Period] as ProectStartMonth, [AOP OpEx], [AOP CapEx], [Total AOP] FROM [lib://Apps/QLIk Sense Sample File.xlsx] (ooxml, embedded labels, header is 1 lines, table is [Forecast Lookup]); [Forecast]: LOAD [Department/Program Name]as [Program Name], [Project/Initative Name]as [Project Name], [Project Alias], //[Type], [Spend Type], //[Project#], //[CC], [Vendor Name/Description] as [Vendor Name], //[Account], [% Allocation], [Resource Name or PO #]as [PO Number], [Resource Commit or PO Amount] as [PO Amount], //[Rate $/hr], //[Est Monthly Burn], //[Comments], [Jan], [Feb], [Mar], [Apr], [May], [Jun], [Jul], [Aug], [Sep], [Oct], [Nov], [Dec], [Year Total] as [Forecast Spend], RangeSum([Jan],[Feb],[Mar])as [Forecast Q1], RangeSum([Apr],[May],[Jun])as [Forecast Q2], RangeSum([Jul],[Aug],[Sep])as [Forecast Q3], RangeSum([Oct],[Nov],[Dec])as [Forecast Q4], [Jan1] as [Jan Spend], [Feb1] as [Feb Spend], [Mar1] as [Mar Spend], [Apr1] as [Apr Spend], [May1] as [May Spend], [Jun1] as [June Spend], [Jul1] as [Jul Spend], [Aug1] as [Aug Spend], [Sep1] as [Sep Spend], [Oct1] as [Oct Spend], [Nov1] as [Nov Spend], [Dec1] as [Dec Spend], [Year Total1] as [Actual Spend], RangeSum([Jan1],[Feb1],[Mar1]) as [Spend Q1], RangeSum([Apr1],[May1],[Jun1])as [Spend Q2], RangeSum([Jul1],[Aug1],[Sep1])as [Spend Q3], RangeSum([Oct1],[Nov1],[Dec1])as [Spend Q4] FROM [lib://Apps/QLIk Sense Sample File.xlsx] (ooxml, embedded labels, header is 4 lines, table is Forecast); [Link_Table]: LOAD [Department/Program Name]as [Program Name], [Project/Initative Name]as [Project Name] FROM [lib://Apps/QLIk Sense Sample File.xlsx] (ooxml, embedded labels, header is 4 lines, table is Forecast); Right Join([Link_Table]) Load [Program Name], [Project Name] FROM [lib://Apps/QLIk Sense Sample File.xlsx] (ooxml, embedded labels, header is 1 lines, table is [Forecast Lookup]); //Where Drop Field [Program Name] FROM [Forecast],[Forecast Lookup];