I need to be able to show summary data by year and territory, but not by territory year. What is I need 4 columns, one for each year, and then 4 more columns, one for each territory. In each would be sums of the row data.
So the columns would be:
The 2009 column would sum all territories in 2009, and the east column would sum all years for east.
When I try to do this I get a column with a year, and then four territory columns under that year column - a hierarchy, normally very useful but not what I need in this instance.
Anyone know how to do this?