Excel Pivot Dashboard Enhancement

My reporting workbook already runs on several PivotTables, slicers and a front-page dashboard, but it needs a focused refresh. I want to add new fields to the existing pivots—specifically new categories or groups—so the reports reflect the way the business is now segmented. Once those fields are in place, the current slicers must be updated to recognise them and continue filtering smoothly without breaking any of the formulas, conditional formats or charts tied to the dashboard.

You will be working inside an established file, so preserving the existing layout and styling is important. I will share the workbook and point out the areas to revise; everything else should remain untouched unless a change is required to keep the dashboard dynamic.

Deliverables:
• Updated PivotTables containing the additional categories/groups
• Modified slicers that sync perfectly with the new fields
• A fully functional dashboard that refreshes without errors after the changes

If you are comfortable with advanced PivotTable configuration, slicer customisation and stress-testing Excel dashboards, this should be a straightforward but satisfying task.