Page History

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

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

86. Click on the + button in the Sub Query link. This will open the Sub Query Type menu.panel to the left of the Data step to add a Sub Query.

79. Set the Type to Append, leaving the and Style set to Basic for now.

108. Click Submit Ok to set up the query.

Image Added

11. Now drag in the same fields as the master query. The difference between the two queries will be set up using filter values.

Image AddedImage Removed

Image Added

1. Click on the Refresh link in the Joins area (on the sub query tab) to load the child fields you just added.

Image AddedImage Removed

Image Modified

3. You should now have a join that looks like the one pictured.

4. Click on the Image Removed at the top of the page to progress to the next step (filters).

Image Removed

Image Added

2. In the Filter Values window select 2010 and click on the Submit link to load the filter.

Image AddedImage Removed

3. You should now have the Master Query Filter set, as shown here.

Image RemovedImage Added

4. To set the Sub Query Filter, follow the same steps as above, this time selecting 2009 as the value.

5. You can now click on the Image Removed at the top of the page to view your report.

Image Removed

Image Added

1. You should now have a report that looks like the one pictured here. To make it easier to read you are going add some formatting to it.

Image RemovedImage Added

Image RemovedImage Added

3. Select the Sum Invoiced Amount Column from the dropdown.

Image Added

Image RemovedImage Added

8. You should now have a report that looks like the one pictured here. The columns are clearly labelled to make it easier to read the data.

Image RemovedImage Added

Image Removed

Image Added