Introduction
In this tutorial, we will walk through setting up an append sub query in order to compare two years worth of figures.
...
This will mean that we have Country as a common field for 2014 and 2013 so this will form our join when we add the Append.
Note: sometimes you will have a case where you don't wish to filter the Country list by 2014, this may be because some countries have no results for 2014 yet. In this case you would have Country in the Master Query, and an Append Query for each Invoiced Amount.
...
This will be joined to the Master Query using the Athlete Country field. The query will be filtered by Year = 2013, and will include a copy of the Sum Invoiced Amount field to be filtered.
Initialise
| Section |
|---|
| Column |
|---|
| 1. Click on the Create link and select Report to begin building your report. |
| Column |
|---|
|  Image Modified
|
|
| Section |
|---|
| Column |
|---|
| 2. You should now be on the Initialise Report page. Select the Drag and Drop Builder as the build tool. |
| Column |
|---|
|  Image Modified
|
|
| Section |
|---|
| Column |
|---|
| 3. Select Ski Team as the View. |
| Column |
|---|
|  Image Modified
|
|
Master Query
| Section |
|---|
| Column |
|---|
| 4. Drag and drop the  Image Modified Athelte Country dimension and  Image Modified Invoiced Amount metric into the Columns list. 5. Drag and drop the Image Modified Year dimension into the Filters list. |
| Column |
|---|
|  Image Modified
|
|
Append Query
Create Append
...
| Section |
|---|
| Column |
|---|
| 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. |
| Column |
|---|
| 
|
|
Formatting
| Section |
|---|
| Column |
|---|
| 23. Click on the first Sum Invoiced Amount field's drop down list and select Format. |
| Column |
|---|
|  Image Modified
|
|
| Section |
|---|
| Column |
|---|
| 24. Change the Display name to Invoiced 2014. It's important to do this to provide the user with some context to help differentiate between the queries. |
| Column |
|---|
|  Image Modified
|
|
| Section |
|---|
| Column |
|---|
| 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. |
| Column |
|---|
|  Image Modified
|
|
Save
| Section |
|---|
| Column |
|---|
| 27. Click Report > Save to activate your report. |
| Column |
|---|
|  Image Modified
|
|
| Section |
|---|
| Column |
|---|
| 28. Set the Name of your report to Append Sub Query Tutorial. 29. Set the Description to This report was written using the Sub Query Tutorial. 30. Select Tutorial as the Category. 31. Select Training as the Sub Category. 32. Click Activate to finish. |
| Column |
|---|
|  Image Modified
|
|
| Section |
|---|
| Column |
|---|
| 33. You now have an active Append Sub Query report. |
| Column |
|---|
|  Image Modified
|
|