Cross Tabs

[gmoorthy]

I would like my report to look like this :-

I have a database where I would like to report to look like the example given below. The database has Various Producttypes and subproductypes under them . I want for each month ( which I can get using dates) but i need the report format to look like the one given below. Which is the best way to do it . Also i wanted totals by each row and also by column by each subprodtype


Productype1 Producttype2
Subprod1 Subprod2 Total Subprod1 subprod2
Jan Count Count Count Count
Feb
March
-----
-----
Dec
Total

 

[skrandel]

So,what's the issue? Looks like a simple crosstab witha break on ProductType.

Steve Krandel
VERITAS Software