Need help in Crosstab Jaspersoft Studio

[amit.saini]

Hi, 

Below is the crosstab template where we have 3 dimensions and 3 measures. 

Need help,  if channel, branch & product are row groups and measures are Policies, lives & Premium then what would be the column groups. How we achieve the same cross tab.

Jaspersoft does not allow measures as columns. However, column groups are a mandatory element of the cross tables

		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

 

 

[amit.saini]

Anybody help me out on this pls.