Getting totals per year and state
I need to pull totals per state and year from a database. Right now I have a table with the following columns:
Each year can have multiple projects in the same state, so there are a bunch of California, 2006 entries.
I need the results to look like this:
I know how to do sums, but not grouped by year AND state. Any tips?