Courses / PivotTables & PivotCharts
10. Report Filter
Using the Filters area to create a top-level filter that limits the entire PivotTable output.
PivotTables and PivotCharts
Report Filter
A Report Filter is a top-level filter area in a PivotTable that limits all displayed results to the selected items.
"I want to look at the whole report only for one country (or quarter) without reconfiguring rows or columns."
A Report Filter is a field placed in the Filters area of a PivotTable that restricts the entire table (and any connected PivotChart) to the selected value(s), acting like a global on/off gate for the dataset.
"I want to look at the whole report only for one country (or quarter) without reconfiguring rows or columns."
A Report Filter is a field placed in the Filters area of a PivotTable that restricts the entire table (and any connected PivotChart) to the selected value(s), acting like a global on/off gate for the dataset.