This worked once I added sorting by the Split column. This kept all the various expense categories grouped together. I then exported to Excel and added my own subtotals for each category. I would think this is a common type of report since tax deductions are taken per expense category. All I'm trying to understand is "what did I spend on expense category X last year." Thanks for the tips!
