Cross-Tab: want Total to be subdivided like the columns

[misbrandy]

Hi.
Using CRv10.
I am doing a basic Cross Tab which compares sales totals for 2 years by month for various products. I want the TOTAL column to also be broken down by those 2 years as well. I could put the year in the column or row, but neither way can I get it to show the subtotals by year.

Now, I get:
BLUE RED Total
2006 2007 2006 2007
FEB 0 0 0 5,829 5,829
MAR 0 20 0 9,614 9,633
APR 0 0 1,534 11,330 12,864
JUL 758 0 15,430 0 16,187
Total 777 20 90,643 54,091 145,531



Want to get:

BLUE RED Totals
2006 2007 2006 2007 2006 2007
FEB 0 0 0 5,829 0 5,829
MAR 0 20 0 9,614 0 9,634
APR 0 0 1,534 11,330 1,534 11,330
JUL 758 0 15,430 0 16,188 0
Total 777 20 90,643 54,091 90,643 54,091

 

[lbass]

I would add a second crosstab with the same row field and summary, but only the year as the column field. Overlay this on your first crosstab and then format by suppressing row labels and removing some of the grid lines in the second crosstab.

-LB