---
title: "Set the required filters"
description: "Which filters each row and column needs before you can save, and how the report filters work together."
canonical_url: "https://www.eebz.com/support/reports-playground/filters"
---

Filters decide which data goes into the report. Some rows and columns need a filter set before the report can be saved.

## Open the filters

Click the yellow filter button at the top left of the builder. The **Report parameters** panel opens, with its tabs grouped into Scope, Products, PerfectPage and Time & more.

![The report parameters panel on the Retailers tab, with My Retailers selected and all five importance ratings ticked](/images/support/playground-params-retailers.webp)

The number next to a tab is how many values it has selected. It isn't a warning.

## When a filter is missing

If a row or column needs a filter that isn't set, the filter button and that filter's tab show a red **!**, and **Save & View** stays disabled. Open the tab with the **!** and set it.

![The Dates tab with Weekly selected, no date range chosen and a red ! next to Dates](/images/support/playground-params-dates-missing.webp)

## What each row or column needs

<table>
<thead>
  <tr>
    <th>
      If the report uses…
    </th>
    
    <th>
      You must…
    </th>
    
    <th>
      Starts as
    </th>
  </tr>
</thead>

<tbody>
  <tr>
    <td>
      Territories
    </td>
    
    <td>
      Keep at least one territory
    </td>
    
    <td>
      All territories
    </td>
  </tr>
  
  <tr>
    <td>
      Markets
    </td>
    
    <td>
      Keep at least one market
    </td>
    
    <td>
      All markets
    </td>
  </tr>
  
  <tr>
    <td>
      Products
    </td>
    
    <td>
      Keep at least one product
    </td>
    
    <td>
      All your products
    </td>
  </tr>
  
  <tr>
    <td>
      Retailers
    </td>
    
    <td>
      Choose importance ratings (<strong>
        My Retailers
      </strong>
      
      ) or specific retailers (<strong>
        All Retailers
      </strong>
      
      )
    </td>
    
    <td>
      All importance ratings
    </td>
  </tr>
  
  <tr>
    <td>
      SKUs
    </td>
    
    <td>
      Pick a price list, specific SKUs or SKU attributes
    </td>
    
    <td>
      Nothing picked
    </td>
  </tr>
  
  <tr>
    <td>
      Retailer Owners
    </td>
    
    <td>
      Pick at least one owner
    </td>
    
    <td>
      Nothing picked
    </td>
  </tr>
  
  <tr>
    <td>
      A Weekly or Daily period
    </td>
    
    <td>
      Pick a rolling window, or <strong>
        Range
      </strong>
      
       with a start and an end date
    </td>
    
    <td>
      Live
    </td>
  </tr>
</tbody>
</table>

SKUs is the filter that most often blocks a report, because nothing is picked to start with.

The Weekly or Daily rule applies whether or not Date is the column.

## Retailers: ratings or named retailers

The Retailers tab has two modes, and you can only use one:

- **My Retailers** filters by your importance ratings, from one to five stars. See [rate your key retailers](/support/retailer-importance).
- **All Retailers** filters by retailers you pick by name.

Choosing one clears the other.

## SKUs: one type at a time

![The SKUs tab with Price Lists, SKUs and Attributes options](/images/support/playground-sku-tabs.webp)

Pick SKUs by **Price Lists**, **SKUs** or **Attributes**. Only one type works at a time, and switching type clears your picks. See [price lists](/support/price-lists).

## Set products before SKUs

The SKU and SKU attribute pickers only list SKUs from the products you have selected. Set the Products tab first.

## Dates

Choose a **Period** of Live, Weekly or Daily. For Weekly or Daily, also choose a **Date range**: a rolling window from Last week to Last year, or **Range** for fixed start and end dates.

![The date range list: Last week, Last 2 weeks, Last 4 weeks, Last 2 months, Last quarter, Last year and Range](/images/support/playground-date-range.webp)

## Filters combine

Filters narrow the report together. They don't override each other. A retailer picked by name that is outside your chosen territories won't appear in the report.

## Other filters

- **Packaging** and **Publishers** narrow the products in the report.
- **Ranging** keeps listings that are In range, Missing or Out of range. See [ranging](/support/ranging).
- **Lifecycle** keeps products at chosen lifecycle stages, from Pre order to Paused. See [lifecycle](/support/lifecycle).
- **Scores** filters by PerfectPage score. It only turns on for PerfectPage report types: see [report types](/support/reports-playground/report-types).
- **Advanced** keeps only values equal to, not equal to, greater than or less than a number you enter, or only listings with an active promotion.

## Sitemap

See the full [sitemap](/sitemap.md) for all pages.
