Excel Pivot Table summarize data

This shows you how to summarize data in Excel - this example shows total number for a budget. You can adjust the pivot table so that it shows % of either column (category) total or the grand total and format correctly.