---
id: video/ijaOx9sSfkw
type: video
title: "What's Cooking in Business Central: Wanna Filter on Totals in Analysis Mode?"
summary: Filtering on aggregated (totaled) columns in Business Central's data analysis mode, shown on an accounts receivable report by removing zero amounts with a "greater than zero" filter. The filter can be saved as part of the analysis definition.
tier: official
language: en
tags:
  - analysis mode
  - data analysis
  - filtering
  - totals
  - aggregated columns
system: reporting
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:01:49.654Z"
  flags: []
generated:
  at: "2026-10-07T23:01:49.696Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: e5b9d2ee65e9b58cfad93651b20cf9803392bbbf2afc5a52197d95f20b3f296a
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=ijaOx9sSfkw&t=5s
    title: "What's Cooking in Business Central: Wanna Filter on Totals in Analysis Mode?"
    date: "2025-02-13T15:30:50.000Z"
    commit: null
    t: 5
    quote: you can use in the data analysis feature in business Central you probably already know that you can filter your Fields here
  - kind: video
    url: https://www.youtube.com/watch?v=ijaOx9sSfkw&t=23s
    title: "What's Cooking in Business Central: Wanna Filter on Totals in Analysis Mode?"
    date: "2025-02-13T15:30:50.000Z"
    commit: null
    t: 23
    quote: did you know that you can also filter your totals just like in normal reports in business Central
  - kind: video
    url: https://www.youtube.com/watch?v=ijaOx9sSfkw&t=43s
    title: "What's Cooking in Business Central: Wanna Filter on Totals in Analysis Mode?"
    date: "2025-02-13T15:30:50.000Z"
    commit: null
    t: 43
    quote: i want to remove all the zero amounts so what i do here is simply on the on this aggregated or totaled
  - kind: video
    url: https://www.youtube.com/watch?v=ijaOx9sSfkw&t=64s
    title: "What's Cooking in Business Central: Wanna Filter on Totals in Analysis Mode?"
    date: "2025-02-13T15:30:50.000Z"
    commit: null
    t: 64
    quote: I can filter here and I can say greater than zero there you go and voila now you have filtered on totals
  - kind: video
    url: https://www.youtube.com/watch?v=ijaOx9sSfkw&t=64s
    title: "What's Cooking in Business Central: Wanna Filter on Totals in Analysis Mode?"
    date: "2025-02-13T15:30:50.000Z"
    commit: null
    t: 64
    quote: you can then save this as part of your data analysis definition
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: ijaOx9sSfkw
channel: yt-microsoft
source_name: Microsoft Dynamics 365 Business Central (YouTube)
url: https://www.youtube.com/watch?v=ijaOx9sSfkw
published_at: "2025-02-13T15:30:50.000Z"
duration_s: 83
captions: full
audience:
  - end user
  - functional consultant
chapters:
  - t: 0
    title: Introduction to the filtering trick
  - t: 23
    title: Demo setup - accounts receivable report
  - t: 43
    title: Filtering totals demo
  - t: 64
    title: Saving filtered analysis definition
features:
  - name: Filter totals in Analysis Mode
    status: unclear
    t: 5
    verified: false
    status_source: video
  - name: Save filtered analysis definition
    status: unclear
    t: 64
    verified: false
    status_source: video
objects_mentioned: []
quotes:
  - t: 5
    text: you can use in the data analysis feature in business Central you probably already know that you can filter your Fields here
    check: exact
  - t: 23
    text: did you know that you can also filter your totals just like in normal reports in business Central
    check: exact
  - t: 43
    text: i want to remove all the zero amounts so what i do here is simply on the on this aggregated or totaled
    check: fuzzy
  - t: 64
    text: I can filter here and I can say greater than zero there you go and voila now you have filtered on totals
    check: exact
  - t: 64
    text: you can then save this as part of your data analysis definition
    check: exact
---

# What's Cooking in Business Central: Wanna Filter on Totals in Analysis Mode?

> Filtering on aggregated (totaled) columns in Business Central's data analysis mode, shown on an accounts receivable report by removing zero amounts with a "greater than zero" filter. The filter can be saved as part of the analysis definition.

[Watch on YouTube](https://www.youtube.com/watch?v=ijaOx9sSfkw) · Microsoft Dynamics 365 Business Central (YouTube) · 2025-02-13 · 1:23 · tier official · reviewed (checked by Opus)

## Overview

A one-minute "What's Cooking in Business Central" clip from February 2025. It starts from the known ability to filter fields in the data analysis feature, then shows that totals can be filtered as well, like in normal reports.

In the demo, an accounts receivable report in analysis mode contains rows with zero amounts. The presenter applies a filter on the aggregated column, setting it to greater than zero, and the zero rows disappear. The filtered setup can then be saved as part of the data analysis definition.

## Key points

- Data analysis mode already lets you filter fields in the analysis filter menu; you can also filter on totals.
- Filtering on totals works on the aggregated (totaled) column, just like in normal reports in Business Central.
- Demo: in an accounts receivable report, a 'greater than zero' filter on the totaled remaining amount column removes the rows with zero amounts.
- The filtered setup can be saved as part of the data analysis definition.

## Chapters

- [0:00](https://www.youtube.com/watch?v=ijaOx9sSfkw&t=0s) Introduction to the filtering trick
- [0:23](https://www.youtube.com/watch?v=ijaOx9sSfkw&t=23s) Demo setup - accounts receivable report
- [0:43](https://www.youtube.com/watch?v=ijaOx9sSfkw&t=43s) Filtering totals demo
- [1:04](https://www.youtube.com/watch?v=ijaOx9sSfkw&t=64s) Saving filtered analysis definition

## Features

| Feature | Status | At |
|---|---|---|
| Filter totals in Analysis Mode | status not stated, demoed | [0:05](https://www.youtube.com/watch?v=ijaOx9sSfkw&t=5s) |
| Save filtered analysis definition | status not stated | [1:04](https://www.youtube.com/watch?v=ijaOx9sSfkw&t=64s) |

## Quotes

- [0:05](https://www.youtube.com/watch?v=ijaOx9sSfkw&t=5s) "you can use in the data analysis feature in business Central you probably already know that you can filter your Fields here"
- [0:23](https://www.youtube.com/watch?v=ijaOx9sSfkw&t=23s) "did you know that you can also filter your totals just like in normal reports in business Central"
- [0:43](https://www.youtube.com/watch?v=ijaOx9sSfkw&t=43s) "i want to remove all the zero amounts so what i do here is simply on the on this aggregated or totaled"
- [1:04](https://www.youtube.com/watch?v=ijaOx9sSfkw&t=64s) "I can filter here and I can say greater than zero there you go and voila now you have filtered on totals"
- [1:04](https://www.youtube.com/watch?v=ijaOx9sSfkw&t=64s) "you can then save this as part of your data analysis definition"