30日間の無料評価版をお試しいただけます。

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
top
top

Table of Contents
classcontents

Introduction

Styleclass
ClasstopLink

...

Append Sub Query

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

...

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

Styleclass
ClasstopLink

...

Append Sub Query

Section
Column
width30%

1. Click on the Create link and select Report to begin building your report.

Column
width70%

...

Section
Column
width30%

3. Select Ski Team as the View.

Column
width70%

Master Query

Styleclass
ClasstopLink

...

Append Sub Query

Section
Column
width30%

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.

Column
width70%

Append Query

Styleclass
ClasstopLink

...

Append Sub Query

Create Append

Section
Column
width30%

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.

Column
width70%

...

Section
Column
width30%

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
width70%

Formatting

Styleclass
ClasstopLink

...

Append Sub Query

Section
Column
width30%

23. Click on the first Sum Invoiced Amount field's drop down list and select Format.

Column
width70%

...

Section
Column
width30%

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
width70%

Save

Styleclass
ClasstopLink

...

Append Sub Query

Section
Column
width30%

27. Click Report > Save to activate your report.

Column
width70%

...

Section
Column
width30%

33. You now have an active Append Sub Query report.

Column
width70%

 

horizontalrule
Styleclass
ClasstopLink

...

Append Sub Query