Break down spending by department and category

Real problems with no formula named for you. You decide what to use.

Finance exported every expense line, including who filed each one. That column won't factor into this. Build a pivot table breaking total spending down by department AND category in a single grid.

The data

This is the actual sheet the case study hands you, including whatever column turns out not to matter. Figuring out what to ignore is part of the exercise.

Why this one matters

A department-by-category cross-tab is the standard shape of an expense review. Ignoring an irrelevant column like who filed each line is half of building it correctly.

More case studies

• Flag the SKUs actually at risk
• Build a dropdown from a list that isn't all still valid
• Total vendor costs using two named ranges together