Dear users:

I am trying to create a pivot table (and possibly a pivot chart) that lists
my daily expenses. I have 3 categories for expenses: cash, debit, and
charge. (I don't really write checks--they would get listed as debit). I
also have 3 categories which are a running =SUM of the first 3 categories.
So I have 6 columns total with dollar amounts in them and then I have 2
additional columns that list what type of purchase and sub-purchase category
it is. (The first 3 columns are date, purchase, and location. The next 3
are cash, debit, charge, the next three are the running totals, and the last
2 are the category columns for what type of purchase it was.) For example, if
I bought a newspaper the category would be news from a drop-down list that I
created.

What I want to do is show a table that adds up all the news items, all the
food items, all the office supplies items, etc. How can I do this with the
type of columns and rows that I have? I tried using Pivot Table wizard but I
ended up with data that didn't have dollar amounts. Instead the data had
weird sorted decimals from .5 to 4.5 or higher. Can someone help me create
the right type of Pivot Table? Thanks in advance for your help.
--
-=- penciline -=-