Totals in Cross Tab Report

[nb4884]

Hi All,

I have a cross tab report, here is how the rows , columns, summaries are displayed.

Rows 10
Summaries 10 Formulae (each summary is a SUM)
Column 1 Formula (This is for year and forms 2 sections, one for all the 10 summary columns for 1 year and the other section is all the 10 summary columns for 2nd year )

So, there are 30 columns in Total.

Now I want to display 2 columns for Total
Column 1 for all summaries for Year 1
And Column 2 for all summaries for Year 2

I need to display both these columns at the end of all the 20 summary columns.

How do i display this?

Here is what I have checked in my customized style
"Row Totals on Left"
"Show Cell Margins"
"Suppress Row Grand Totals"

I tried unchecking "Suppress Row Grand Totals" but this gives me 10 columns for summary totals and looks like its only adding up corresponding Year 1 and Year 2 values. And that is not how I wanted.

Do I need to create anothe r formula for sum?

Thanks!

Ver CR XI