First question here. I'm a competent enough programmer but I'm wondering if there's an excel-like way to solve this. Lets say I have three columns: account #, date, expenditure. I want to see each accounts' expenditure via year. If I wanted to just see the gross total for all years per account, I know I could use the subtotal option. However, there doesn't seem to be an option to differentiate on more than one column (unlike the 'sort' function). What does SU recommend?
You can differentiate on more than one column in Excel. To do this, check each of your column names in the below window (under "Add subtotal to:"):