Build a pivot table

I need a pivot for next week’s budget meeting. Create a pivot that rows by Department, columns by Quarter, values showing Sum of Expense Amount with number formatting, and a grand total for each Department. Place the pivot on a new sheet and name it Department Expenses Q1–Q3.

Before I present the pivot to the execs, make it approval-friendly: show Sum of Expense Amount and Count of Transactions, collapse quarters so the latest quarter is expanded by default, sort departments by descending total expense, and add a short note explaining any unusually large single transactions. Highlight departments with month-over-month increases above 20 percent.

I built a pivot for Department expenses but several departments show zero while I can see expense rows in the raw data. I’m preparing for the budget review and the CFO will notice. Could this be due to blank department cells, mismatched data types in Amount, or the pivot’s source range being wrong? What’s the fastest diagnostic and fix so the pivot reflects the raw data correctly?

I keep rebuilding pivots for each meeting because sources change, and each rebuild costs me hours and looks amateur to execs. Where am I losing time or making the wrong assumptions about source ranges and data hygiene, and what one habit or sheet layout change will cut pivot rebuild time in half going forward?