DBIx::SQLCrosstab Example

area	country	location	pers						sales							dev					total
			employee			contractor		total	employee		contractor		consultant		total	employee		consultant		total
			f	m	total	m	total	total	m	total	m	total	f	total	total	m	total	f	total	total
North	Germany	Berlin	5,500	0	5,500	0	0	5,500	0	0	0	0	0	0	0	6,000	6,000	0	0	6,000	11,500
		Bonn	0	0	0	0	0	0	5,000	5,000	0	0	0	0	5,000	0	0	0	0	0	5,000
		Munich	0	5,000	5,000	0	0	5,000	0	0	0	0	5,500	5,500	5,500	0	0	0	0	0	10,500
		total	5,500	5,000	10,500	0	0	10,500	5,000	5,000	0	0	5,500	5,500	10,500	6,000	6,000	0	0	6,000	27,000
	UK	London	0	0	0	5,000	5,000	5,000	0	0	5,500	5,500	0	0	5,500	0	0	0	0	0	10,500
	UK	total	0	0	0	5,000	5,000	5,000	0	0	5,500	5,500	0	0	5,500	0	0	0	0	0	10,500
	total	total	5,500	5,000	10,500	5,000	5,000	15,500	5,000	5,000	5,500	5,500	5,500	5,500	16,000	6,000	6,000	0	0	6,000	37,500
South	Italy	Rome	0	6,000	6,000	0	0	6,000	0	0	0	0	0	0	0	0	0	6,000	6,000	6,000	12,000
	Italy	total	0	6,000	6,000	0	0	6,000	0	0	0	0	0	0	0	0	0	6,000	6,000	6,000	12,000
	total	total	0	6,000	6,000	0	0	6,000	0	0	0	0	0	0	0	0	0	6,000	6,000	6,000	12,000
total	total	total	5,500	11,000	16,500	5,000	5,000	21,500	5,000	5,000	5,500	5,500	5,500	5,500	16,000	6,000	6,000	6,000	6,000	12,000	49,500

Operation COUNT SUM AVG MIN MAX	Rows area country location	Columns dept category gender	Exclude from dept pers sales dev	Exclude from category employee consultant contractor	Exclude from gender m f
Additional operations COUNTSUMAVGMINMAX
Query options add_colors add_real_names col_sub_total col_total commify remove_if_null remove_if_zero row_sub_total row_total title_in_header use_real_names		Additional formats none list of lists list of (simple) hashes list of (tree-like) hashes hash of hashes (tree) Comma separated values (CSV) YAML XML simple HTML table SQL SQL (highlighted syntax) crosstab parameters