> ## Documentation Index
> Fetch the complete documentation index at: https://quikirr.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Filtering

> Review subsets or segments of your data by creating and applying filters to your analyses.

***

## Fine‑Tune with the Filter Center

<img src="https://mintcdn.com/quikirr/xIRaGjBuBRBt9dNh/images/filter/FilterBuilder.png?fit=max&auto=format&n=xIRaGjBuBRBt9dNh&q=85&s=88e567b16c54cd1cff4b8f6a36b28ea4" alt="Filter Center with multi‑select dimensions" className="rounded-xl border border-gray-200 shadow-sm" width="958" height="536" data-path="images/filter/FilterBuilder.png" />

* Choose a single filter or combine multiple dimensions (e.g., Country, End Market, Region) using flexible AND / OR logic to define precise data slices. Filters correspond to the 'Descriptors' during ingest data tagging.
* Save filter combinations and instantly preview any saved filter set within the interactive analysis views.
* Assign saved filters to any analysis within the Workbook Designer, such as cohorts analysis, unit economics, or ARR waterfalls, to generate filtered Excel worksheets with dynamic toggles.

<Card img="https://mintcdn.com/quikirr/xIRaGjBuBRBt9dNh/images/filter/FilterDashboardView.png?fit=max&auto=format&n=xIRaGjBuBRBt9dNh&q=85&s=e2d6f757b78c06ef713a095bc7bcbb4d" width="923" height="476" data-path="images/filter/FilterDashboardView.png">
  Dashboard view with filter applied.
</Card>

***

## Excel Workbook: Dynamic Toggles

<img src="https://mintcdn.com/quikirr/xIRaGjBuBRBt9dNh/images/filter/FilterTagsActivate.png?fit=max&auto=format&n=xIRaGjBuBRBt9dNh&q=85&s=1c85f6054a9f02d64df65758925ae68e" alt="Excel filter sheet with TRUE/FALSE toggles" className="rounded-xl border border-gray-200 shadow-sm" width="755" height="257" data-path="images/filter/FilterTagsActivate.png" />

Each export includes a **Filters** worksheet that mirrors your saved combinations:

* **Set Filter Values**: yellow input cells list the dimension values in each option.
* **Apply Filters**: toggle cells (`TRUE` / `FALSE`) switch the current view across every sheet in the model.
* Changes cascade instantly thanks to dynamic formulas.

***

See also [Segment Waterfalls](/features/waterfalls#segment-waterfalls).

## Workflow Recap

1. **Define filter combos** in the Filter Center.<br />
2. **Preview the filters** in the dashboard top bar, from the Waterfalls view for instance.<br />
3. Assign the filter to an analysis via the Workbook Designer page to generate the relevant tabs in the Excel workbook.<br />
4. Dynamically toggle filters directly in Excel with live data refresh.