The idea1 / 13
What are we solving today?
A PivotTable groups source records by fields you choose, such as department and week, and calculates a summary without changing the original data. A reliable summary depends on source quality, aggregation type, filtering, and refreshing, not just the table's appearance.
After this stop…
Build a participation summary by department and week, select the correct aggregation, and try filtering and refreshing to see how the summary responds to its source.