C:\Users\markt\Downloads\ChallengeX_Frei_Mitchell-selected\ChallengeX_Revenue_Actual.xlsx|||`Revenue Actual$` False 1 Actual ChallengeX_Revenue_Actual.xlsx Query=`Revenue Actual$` C:\Users\markt\Downloads\ChallengeX_Frei_Mitchell-selected\ChallengeX_Revenue_Plan.xlsx|||`Revenue Plan$` False 1 Plan ChallengeX_Revenue_Plan.xlsx Query=`Revenue Plan$` Sum Revenue Sum Revenue Sum Planned Revenue Sum Planned Revenue Simple DateRange Date True fixed 2023-02-07 22:04:32 days 0 2022-04-01 2023-03-31 [Date] >= "2022-04-01" AND [Date] <= "2023-03-31" C:\Users\markt\AppData\Local\Temp\Engine_28104_a2f33e04c4f7473da829ee9bc11eb0c4_\Engine_29308_241a7708b3d142b5bd0fa0f54e654e73_.yxdb Single Profile 1 1 Sum Revenue by Region Sum Revenue by Region Sum Planned Revenue by Region Sum Planned Revenue by Region Join the two datasets by Region Join the two datasets by Region C:\Users\markt\AppData\Local\Temp\Engine_28104_a2f33e04c4f7473da829ee9bc11eb0c4_\Engine_29308_0bc56802c1c44d73906666a950c88768_.yxdb Single Profile 2 1 Actual v Plan % - Ascending Sum of Actual Revenue by Practice Sum of Actual Revenue by Practice Sum of Planned Revenue by Practice Sum of Planned Revenue by Practice Simple = Region True fixed 2023-02-07 21:41:16 0 South 2023-02-07 21:41:16 2023-02-07 21:41:16 [Region] = "South" Simple = Region True fixed 2023-02-07 21:41:16 0 South 2023-02-07 21:41:16 2023-02-07 21:41:16 [Region] = "South" Join the two datasets Join the two datasets C:\Users\markt\AppData\Local\Temp\Engine_28104_a2f33e04c4f7473da829ee9bc11eb0c4_\Engine_29308_d19ffdb194ad47a89bb9c64fcdf3e46f_.yxdb Single Profile 3 2 Actual v Plan % - Ascending Error Append Actual and Planned Revenue columns Horizontal MitchChallenge