Page History

3. Select Ski Team as the View.

4. Drag and drop the Athelte Country dimension and Invoiced Amount metric into the Columns list.

5. Drag and drop the Year dimension into the Filters list.

6. Click on the + button in the Sub Query panel to the left of the Data step to add a Sub Query.

7. Set the Type to Append and Style to Basic.

8. Click Ok to set up the query.

The first thing you will need to define, when setting up a sub query, is the join type, and join fields.

9. Ensure the join type is Left Outer Join.

10. Select the Athlete Country field in the Master Query Fields drop down list. This is the field you wish to join the Sub Query to.

11. Drag the Athlete Country field in to the *Sub Query Fields box in order to join it to the Master Query.

12. Add the Year field to the Sub Query Filters box. This filter will be used to restrict results of the sub query only.

13. Change the name of the Sub Query to Previous Year. This will later help identify the sub query, especially useful if you have multiple sub queries.

14. Save the Sub Query.

15. Drag and drop the Invoiced Amount metric into the Columns list.

16. If you need to make changes to your sub query setup at all, click the Edit Settings link.

17. Once your sub query is ready, navigate back to the Master Query by clicking on it in the sub query panel on the left of the page.

18. Click on the Settings link in the Filters panel. This will allow you to configure logic and values for all filters.

19. Set the Master Query filter to be Year Equal to 2014 by clicking on the funnel icon.

20. Select 2014 and click submit

21. Navigate to the sub query filters by clicking on the Previous Year tab.

22. Click on the x on the filter panel to close it. Be sure not to click on the X to close the report builder.

25. While still in the Column Formatting menu, select the Sum Invoiced Amount field from the list on the left.

26. Set the name to Invoiced 2013 and close the menu.