Like what you see? Have a play with our trial version.

Versions Compared

Key

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

...

  1. Create a new report
  2. Use your mouse to drag your data from the left panel to the Columns, Sections and Filters fields
    In this example, we have selected Athlete Country, Invoiced Amount and Year as the data for our master query


  3. Click the + Image Added tool on the left navigation menu to display the Sub Query panel
  4. For this example, select Append as the type, Basic as the style, and click the OK button


  5. Tick the Link on View Fields checkbox


  6. Click on the Master Query Fields search field
    The dropdown list will display all available fields within the view, allowing you to join your sub query and master query via any field, in this case Age at Camp


  7. Untick the Link on View Fields checkbox to reset the dropdown list to the fields available within your master query

...