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.

Before you start
The pipeline Pivot Table from Summarize Pipeline by Stage and Quarter, or any Pivot Table on Opportunity.
Opportunities with a Lead Source filled in.
Steps
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.

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.

Save and test
Click Save and open the page.
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".
Click Export. The Export dialog opens with your File Name, the two Export View options and the Format list.
Click Export. The file downloads with the name you set, and holds the filtered table only.

Troubleshooting
Related tutorials
Summarize Pipeline by Stage and Quarter: the table these filters narrow.
Export To: the interaction reference.
Was this helpful?
