Add another crosstab total

[fheswara]

Hi All,

Can i create this with crosstab, here is my sample report:

 

EDUCATION		AGE	CERTIFICATE		TOTAL
			01	03
00		04	80	50	130
		05	30	20	50
	TOTAL		110	70	180
01		04	20	20	40
		05	10	20	30
		06	60	60	120
	TOTAL		90	100	190

Is it possible to do it under crosstab? the reason why i choose crosstab is because CERTIFICATE COLUMN it's dynamic, it can have a value more than 2 (01, 03, 05, 07, 08, etc..) so it's dynamic column. i can solved it.

But i have 1 big problem, how to create TOTAL more than 1 in crosstab? is it possible to do it? Please let me know for this.

Thanks a lot

[alvintkl]

yap can

you can use group by education and Age

 

[fheswara]

Hi,

 

Thanks, it's solved