---
title: "Minus Sub Query"
canonical: "https://wiki.yellowfinbi.com/space/USER73Plus/1376665/Minus%20Sub%20Query"
format: markdown
---
> Macro (anchor)



> Macro (toc)

## 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.

In this scenario our main report will have a list of athletes that attended camps in the current year. We will then remove athletes from that list that are in the minus list (athletes from prior to the current year), leaving us with only athletes attending camps for the first time this year.

 

> Macro (html-bobswift)

 


 

## Create


> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

 

 

## Master Query


> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

 

## Minus Query


### Create Minus

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

 

### Configure Minus

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

 

### Edit Settings

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

 

## Apply Filters


> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

 

### Master Filter

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

 

### Sub Query Filter

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

 

## Save


> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)