Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Filter and Export a Pivot Table

Add lead source and owner filters to a pipeline pivot table, then an Export button, so a manager narrows the summary and takes it to a meeting in Excel.

Before the quarterly review, a regional manager wants the pipeline summary for web leads only, then a copy of it in Excel for the slides. Header filters narrow the table without a second component, and an Export button downloads the filtered table with its totals.

Pipeline pivot table filtered on the Web lead source, with Lead Source and Owner filters and an Export button in the header
The header filters narrow the totals before the export.

Before you start

Steps

1

Choose the filter fields

  1. Select the Pivot Table. In Data Mappings, open Filters.

  2. Select Lead Source, then Owner ID. On the page, that filter button reads Owner.

Each field becomes a filter in the table header. You can reorder the selected fields in the list.

2

Decide how the filters look

Open the Filter section.

  • Display As Popover: turn it on to put every filter behind a single button. Leave it off to show one button per filter in the header.

  • Use Record Picklist Values: turn it on so Lead Source only offers values found in the deals, instead of every value defined on the field.

  • Use Cascading Filter Values: turn it on so that, once a lead source is picked, Owner only lists owners who have deals from that source.

Filters set to Lead Source and Owner ID, and the Filter section with Display As Popover, Use Record Picklist Values and Use Cascading Filter Values
Pick the filter fields, then how they are shown.
3

Add an Export button

  1. Open the Header section and add an item to Actions.

  2. Label: Export. Name: export. Icon Name: utility:download.

4

Connect the button to Export To

  1. Open the Interactions tab and add an interaction under Header Action Click.

  2. Target Name: Export.

  3. Type: Export To.

5

Set the export defaults

These values pre-fill the export dialog. The end user can still change them, unless you hide the dialog.

  • Default File Name: Pipeline by Stage and Quarter.

  • Default Export View: keep Formatted Report, the default. It keeps the layout of the table, with its headers, totals and currency format. Details Only gives the same grid with plain numbers.

  • Available File Formats: keep Excel only for a file the manager opens in Excel, or both CSV and Excel to let them choose. With both, the dialog offers .xlsx (selected first), .xls and .csv.

  • Default Encoding Type: Unicode (UTF-8), the default, suits most tools. It only applies to a CSV file.

  • Hide Export Dialog: downloads the file at once with these defaults, as .xlsx when Excel is available. Leave Default File Name empty and the file is named after the object, such as Opportunity.

Export To settings on the Header Action Click interaction of the Export button
The defaults the export dialog opens with.
6

Save and test

Click Save and open the page.

  1. Open the Lead Source filter and pick Web. The totals drop to web deals only. Pick an owner in Owner too: both filters apply, and the line under the title reads "Filtered by Lead Source, Owner".

  2. Click Export. The Export dialog opens with your File Name, the two Export View options and the Format list.

  3. Click Export. The file downloads with the name you set, and holds the filtered table only.

Export dialog with the file name, the Formatted Report and Details Only views and the file format
The end user confirms or changes the defaults before the download.

Troubleshooting

Year or quarter headers look like dates in the file

With Formatted Report, a column grouped by Year or Quarter can come out of the export as a date (2025-12-31 for the year 2026, 2001-01-01 for quarter 1). Pick Details Only in the dialog: its headers are right, and only the currency format is lost.

The Export button does nothing

No Header Action Click interaction targets the button, or its Type is not Export To. Open the Interactions tab and check Target Name and Type.

Lead Source lists values no deal uses

Turn on Use Record Picklist Values in the Filter section. The filter then offers only the values found in the records.

Was this helpful?