Is there a way to have a sub total include a different variable? To be clear, I have three columns, the last column is year. I add sub-total but it sub totals to attribute #1 which is ok, but I want to see the sub total by also the year. Is this possible?
The below is what I want, what i get now is the sub total of only the first column.
The subtotals cannot be added to year if they are in the last column, as it currently is. The 2 rows for 2012 aren't next to each other. By moving it to the left of Level 2 Call, you'll be able to add the subtotal for year.