---
id: video/yE6lNV3ALb4
type: video
title: Add a Pivot Table with Live Data in your Spreadsheet inside Business Central (Advanced Spreadsheets)
summary: Pivot tables with live data in Business Central spreadsheets, using the advanced spreadsheets and reporting app. The demo builds a pivot table on item ledger entries, shows refresh on open, drilldown to source records, and changing date buckets to quarters.
tier: community
language: en
tags:
  - pivot tables
  - live data
  - advanced spreadsheets
  - data analysis
  - interactive reporting
  - item ledger entries
  - data visualization
  - spreadsheet automation
system: reporting
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:18:01.085Z"
  flags: []
generated:
  at: "2026-10-13T00:32:41.360Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: ef1eec1df18aac1bc7d00f107ecefa9de2321c3bc3296464be96c8ea1cb77f97
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=yE6lNV3ALb4&t=0s
    title: Add a Pivot Table with Live Data in your Spreadsheet inside Business Central (Advanced Spreadsheets)
    date: "2026-09-21T19:14:19.000Z"
    commit: null
    t: 0
    quote: How to add a pivot table with live data in your spreadsheet using the advanced spreadsheets and reporting app for Business Central?
  - kind: video
    url: https://www.youtube.com/watch?v=yE6lNV3ALb4&t=37s
    title: Add a Pivot Table with Live Data in your Spreadsheet inside Business Central (Advanced Spreadsheets)
    date: "2026-09-21T19:14:19.000Z"
    commit: null
    t: 37
    quote: With live data. Let's go for item ledger entries. And maybe let's add a filter here.
  - kind: video
    url: https://www.youtube.com/watch?v=yE6lNV3ALb4&t=89s
    title: Add a Pivot Table with Live Data in your Spreadsheet inside Business Central (Advanced Spreadsheets)
    date: "2026-09-21T19:14:19.000Z"
    commit: null
    t: 89
    quote: And this is live data. So if if you hit the the refresh it will be refreshed. Whenever you open it, it's refreshed.
  - kind: video
    url: https://www.youtube.com/watch?v=yE6lNV3ALb4&t=102s
    title: Add a Pivot Table with Live Data in your Spreadsheet inside Business Central (Advanced Spreadsheets)
    date: "2026-09-21T19:14:19.000Z"
    commit: null
    t: 102
    quote: I control click and I get the item ledger entries. That'd be the thousand to take we worked on.
  - kind: video
    url: https://www.youtube.com/watch?v=yE6lNV3ALb4&t=130s
    title: Add a Pivot Table with Live Data in your Spreadsheet inside Business Central (Advanced Spreadsheets)
    date: "2026-09-21T19:14:19.000Z"
    commit: null
    t: 130
    quote: We can go in and and we can say, "Okay, hang on. Let's change the buckets to be quarters instead." And now we have
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: yE6lNV3ALb4
channel: yt-hougaard
source_name: Erik Hougaard
url: https://www.youtube.com/watch?v=yE6lNV3ALb4
published_at: "2026-09-21T19:14:19.000Z"
duration_s: 165
captions: derived
audience:
  - functional consultant
  - end user
  - administrator
chapters:
  - t: 0
    title: Introduction to pivot tables with live data
  - t: 13
    title: Creating a new pivot table region
  - t: 37
    title: Configuring data source and pivot table fields
  - t: 76
    title: Completing the pivot table and viewing results
  - t: 102
    title: Interacting with live data and drilldown capability
  - t: 130
    title: Modifying pivot table structure and data reusability
  - t: 152
    title: Conclusion and sandbox trial
features:
  - name: Pivot tables with live data in spreadsheets
    status: unclear
    t: 0
    verified: false
    status_source: video
  - name: Pivot table field configuration
    status: unclear
    t: 37
    verified: false
    status_source: video
  - name: Drilldown from pivot table to source data
    status: unclear
    t: 102
    verified: false
    status_source: video
  - name: Spreadsheet-based pivot table data reusability
    status: unclear
    t: 116
    verified: false
    status_source: video
objects_mentioned:
  - table item ledger entries
quotes:
  - t: 0
    text: How to add a pivot table with live data in your spreadsheet using the advanced spreadsheets and reporting app for Business Central?
    check: exact
  - t: 37
    text: With live data. Let's go for item ledger entries. And maybe let's add a filter here.
    check: exact
  - t: 89
    text: And this is live data. So if if you hit the the refresh it will be refreshed. Whenever you open it, it's refreshed.
    check: exact
  - t: 102
    text: I control click and I get the item ledger entries. That'd be the thousand to take we worked on.
    check: exact
  - t: 130
    text: We can go in and and we can say, "Okay, hang on. Let's change the buckets to be quarters instead." And now we have
    check: exact
---

# Add a Pivot Table with Live Data in your Spreadsheet inside Business Central (Advanced Spreadsheets)

> Pivot tables with live data in Business Central spreadsheets, using the advanced spreadsheets and reporting app. The demo builds a pivot table on item ledger entries, shows refresh on open, drilldown to source records, and changing date buckets to quarters.

[Watch on YouTube](https://www.youtube.com/watch?v=yE6lNV3ALb4) · Erik Hougaard · 2026-09-21 · 2:45 · tier community · reviewed (checked by Opus)

## Overview

Erik Hougaard shows in about three minutes how to add a pivot table region to a spreadsheet in Business Central with the advanced spreadsheets and reporting app. He picks item ledger entries as the data source, adds a filter, and sets row and column fields and the values to aggregate.

Once built, the pivot table shows live data. It refreshes whenever the spreadsheet is opened and can be refreshed by hand. Control-clicking a cell opens the item ledger entries behind the number. The structure can be changed, for example by switching date buckets to quarters, and the result stays spreadsheet data that can feed other calculations. A link to try it in a cloud sandbox is given.

## Key points

- The demo adds a pivot table with live data using the advanced spreadsheets and reporting app for Business Central.
- A new pivot table region is created in the spreadsheet, then a data source (item ledger entries in the demo) is chosen and can be filtered.
- Row fields, column fields and the summed value field (quantity in the demo) are configured in the pivot table setup.
- Date fields can be bucketed, for example changed to quarters, after the pivot table is built.
- The data refreshes whenever the spreadsheet is opened and can also be refreshed manually.
- Control-click a pivot cell to drill down to the underlying item ledger entries.
- Pivot table output stays spreadsheet data, so it can serve as input for other calculations.

## Chapters

- [0:00](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=0s) Introduction to pivot tables with live data
- [0:13](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=13s) Creating a new pivot table region
- [0:37](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=37s) Configuring data source and pivot table fields
- [1:16](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=76s) Completing the pivot table and viewing results
- [1:42](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=102s) Interacting with live data and drilldown capability
- [2:10](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=130s) Modifying pivot table structure and data reusability
- [2:32](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=152s) Conclusion and sandbox trial

## Features

Every feature below: status not stated, demoed.

| Feature | At |
|---|---|
| Pivot tables with live data in spreadsheets | [0:00](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=0s) |
| Pivot table field configuration | [0:37](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=37s) |
| Drilldown from pivot table to source data | [1:42](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=102s) |
| Spreadsheet-based pivot table data reusability | [1:56](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=116s) |

## AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

- table "item ledger entries" at [0:37](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=37s)

Not found in BC28-30: table "item ledger entries".

## Quotes

- [0:00](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=0s) "How to add a pivot table with live data in your spreadsheet using the advanced spreadsheets and reporting app for Business Central?"
- [0:37](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=37s) "With live data. Let's go for item ledger entries. And maybe let's add a filter here."
- [1:29](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=89s) "And this is live data. So if if you hit the the refresh it will be refreshed. Whenever you open it, it's refreshed."
- [1:42](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=102s) "I control click and I get the item ledger entries. That'd be the thousand to take we worked on."
- [2:10](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=130s) "We can go in and and we can say, "Okay, hang on. Let's change the buckets to be quarters instead." And now we have"

## Disclaimers in the video

- [2:32](https://www.youtube.com/watch?v=yE6lNV3ALb4&t=152s) other: What you can do is click the link below and you can try this out for free in a cloud sandbox.

Presenters (as heard): Eric.