Versions Compared

Key

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

Anchor
top
top

Table of Contents
classcontents

Introduction

In this tutorial, we will walk through setting up a Minus sub query. A good way to think about Minuses is - use them if you need a list of something, not including results found in another list.

...

Section
Column
width30%

25. Set the Name of your report to Minus Sub Query Tutorial.

26. Set the Description to This report was written using the Sub Query Tutorial.

27. Select Tutorial as the Category.

28. Select Training as the Sub Category.

29. Click Activate to finish.

30. You now have an active Minus Sub Query report. There will be no results as there is only a small number of transactions for 2014, and no new customers among them. If you change the filters to be Master = 2013 and Minus < 2013 there will be results.

Column
width70%