Filter values in pivot table

I have a spreadsheet set up as a budget tool. I have a dynamic named range set up where I enter income (positive values) and expenses (negative values). I'm able to do most of what I want with it, but I can't figure out a non-clumsy way of making a pivot table to show the sum of the negative values only (expenses) within a given time frame.

If I set up a pivot table with Rows = Category (like Rent, Utilities, etc) and Value = Sum of Amount, and then try to use a value filter on my rows column, it wants to filter by sum of amount, and shows me only the entries where income plus expenses for that category equals a negative amount.

I can add amount to the filter, then hand select, or use a slider to select every value that is less than 0, but that's really tedious, and I'd have to re-do it every time I entered a new amount that was less than 0.

I could also add another field to my dataset like Expense Yes/No, or "E" for expense, "I" for income, but that feels clunky and redundant to me, since I already know whether it's income or expense by virtue of whether the amount is negative or positive.

Is there any quick and easy way to display in the value column the sum of the negative values only?

OK I stripped it down, my actual spreadsheet has macros and things, so I took that out, it should be "safe." Also removed most of the data, just leaving enough to have something to work with. It's the second pivot table I'm trying to deal with.

No, that's not quite doing what I'm wanting.

The Sum of expenses should look like this:

-$20.74 Insurance
-$12.82 Eating Out
-$79.00 Energy
-$20.98 Hobby
-$790.00 Rent
-$11.87 Pet
-$34.23 Gas
-$7.99 Entertainment

-$977.63 Total

I want to add up all the negative values in each category and totally disregard the positive values.

I have two tables, one to show what's "left" in each category right now (income minus expenses) and one to show what I've spent, regardless of how much I've put in.

Hi,

It looks to me that you have 2 alternatives by adding an additional column:-
1. then add a Totals Row to your balance sheet table
2. or create a pivot table based on the new balance sheet table
I have shown both on your balance sheet (tab) - see attached.

peterrc