Cross Tab Query

[aashnanahar]

Hi All,

I have customized a cross tab report.I need help in consolidating the data in one a single detail section of the crosstab, please refer the screenshot attached

The desired report should look like the below :

		No. of Policies	No. of Lives	Gross Premium
Channel	CH01	1000	1800	$200,000
	Branch1	250	500	$50,000
	ProductA	100	250	$20,000
	ProductB	75	100	$15,000
	ProductC	75	150	$15,000
	Branch2	750	1300	$150,000
	ProductD	500	1000	$100,000
	ProductE	250	300	$50,000

Please let me know the solution to this.

[aashnanahar]

Hi ALL,

has anybody tackled this scenario before...please help