Forum Discussion
Automatically sum categories in a pivot table?
I have a simple table of about 1,200 transactions (rows) of three columns (Vendor, amount, date). Most of the transactions are from the same 125 or so vendors. Some vendors have 25-30 transactions, m...
I'd create a pivot table based on the data. Add the Vendor field (column) to the Rows area and the Amount field to the Values area.