I have a spreadsheet that I use to track expenses. Each expense has a Month and date and category and an amount. I am trying to use a pivot table to give me total expenses by category by month and monthly total expenses. When I try and build this one, I do not seem to be able to get the amount totals, but only total counts of each category in each month. What do I need to do to get the total expenses by category, rather than the count by category? Any insight anyone can provide is greatly appreciated. Thanks.
Ron M