show all crosstab generated subtotals together

[kunaljvora]

Hi

I have the following Cross tab output:

Total 2011 01/11 02/11 .. 12/11 Total 2012 01/12 02/12..

Prod 1
Prod 2
Prod 3

The 01/11, 02/11 represent MM/YYYY which are grouped by @Year and I am generating a cross tab summary of Annual Sum.

The issue is the annual total (cross tab generated) appears before the beginning of every year (2011, 2012..)

Is there a way to show all the annual summaries on the left and then the MM/YYYY data?

like

total 2011 total 2012 total 2013 | Jan 11 Feb 11.. Dec 13

Prod 1
Prod 2
Prod 3


Please suggest if this is possible with Crystal reports Cross tab

Thanks
Kunal

 

[IanWaterman]

you will need two cross tabs, but second monthly one will need to be postioned to allow for growth of the first annual one.

Ian

 

[kunaljvora]

Thanks, that worked