Courses / PivotTables & PivotCharts
11. Manual filtering of labels
Using the label filter dropdowns in Row/Column fields to include/exclude items and apply label-based filters.
PivotTables and PivotCharts (Excel)
Manual filtering of labels
Using the Row/Column field label dropdown to include or exclude specific items or to apply label-based filters.
"I only want to show the five regions I'm presenting and hide everything else — but still filter by product name when needed."
Manual label filtering is selecting or clearing checkboxes in a pivot field's label dropdown (or using Label Filters) to show only the row/column items you want. It can include/exclude specific items or apply text/label rules like "Begins With" or "Contains."
"I only want to show the five regions I'm presenting and hide everything else — but still filter by product name when needed."
Manual label filtering is selecting or clearing checkboxes in a pivot field's label dropdown (or using Label Filters) to show only the row/column items you want. It can include/exclude specific items or apply text/label rules like "Begins With" or "Contains."