Page History

Introduction

In this tutorial, we will walk through setting up an append sub query in order to compare two years worth of figures.

A good way to think about Appends is - use them if you need to add a column to a report that requires filters different to the rest of the report.

In this scenario our main report will look at invoice figures by country in 2014. The column we want to add is the invoiced figures in 2013. The filters Year = 2014 and Year = 2013 conflict, so the additional column will have to be added through the append.

Master Query

The Master Query is going to include:

1. Athlete Country
2. Sum Invoiced Amount
3. Filter: Year = 2014

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.

Append Query

The Append Query will include:

1. Join: Athlete Country
2. Sum Invoiced Amount
3. Filter: Year = 2013

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

...

Master Query

Append Query

...