Crosstab queries calculate a sum, average, count, or other type of total for data that is grouped by two types of information – one down the left side of the datasheet and another across the top.
1	Crosstab	crosstab	NOUN	SG-NOM	Number=Sing	2	compound	_	_
2	queries	query	NOUN	PL-NOM	Number=Plur	3	nsubj	_	_
3	calculate	calculate	VERB	PRES	Mood=Ind|Tense=Pres|VerbForm=Fin	0	root	_	_
4	a	a	DET	IND-SG	Definite=Ind|PronType=Art	5	det	_	_
5	sum	sum	NOUN	SG-NOM	Number=Sing	3	obj	_	SpaceAfter=No
6	,	,	PUNCT	Comma	_	7	punct	_	_
7	average	average	NOUN	SG-NOM	Number=Sing	5	conj	_	SpaceAfter=No
8	,	,	PUNCT	Comma	_	7	punct	_	_
9	count	count	NOUN	SG-NOM	Number=Sing	5	conj	_	SpaceAfter=No
10	,	,	PUNCT	Comma	_	13	punct	_	_
11	or	or	CCONJ	_	_	13	cc	_	_
12	other	other	ADJ	POS	Degree=Pos	13	amod	_	_
13	type	type	NOUN	SG-NOM	Number=Sing	5	conj	_	_
14	of	of	ADP	_	_	15	case	_	_
15	total	total	ADJ	POS	Degree=Pos	13	amod	_	_
16	for	for	ADP	_	_	17	case	_	_
17	data	data	NOUN	PL-NOM	Number=Sing	15	nmod	_	_
18	that	that	PRON	REL	PronType=Rel	20	nsubj	_	_
19	is	be	AUX	PRES-AUX	Mood=Ind|Number=Sing|Person=3|Tense=Pres|VerbForm=Fin	20	aux:pass	_	_
20	grouped	group	VERB	PASS	Tense=Past|VerbForm=Part|Voice=Pass	17	acl:relcl	_	_
21	by	by	ADP	_	_	23	case	_	_
22	two	two	NUM	CARD-PL	NumType=Card	23	nummod	_	_
23	types	type	NOUN	PL-NOM	Number=Plur	20	obl	_	_
24	of	of	ADP	_	_	25	case	_	_
25	information	information	NOUN	SG-NOM	Number=Sing	23	nmod	_	_
26	–	–	PUNCT	Dash	_	27	punct	_	_
27	one	one	PRON	IND-SG-NOM	_	23	nmod	_	_
28	down	down	ADP	_	_	31	case	_	_
29	the	the	DET	DEF	Definite=Def|PronType=Art	31	det	_	_
30	left	left	ADJ	POS	Degree=Pos	31	amod	_	_
31	side	side	NOUN	SG-NOM	Number=Sing	27	nmod	_	_
32	of	of	ADP	_	_	34	case	_	_
33	the	the	DET	DEF	Definite=Def|PronType=Art	34	det	_	_
34	datasheet	datasheet	NOUN	SG-NOM	Number=Sing	31	nmod	_	_
35	and	and	CCONJ	_	_	36	cc	_	_
36	another	another	PRON	ADJ-SG	Case=Nom	27	conj	_	_
37	across	across	ADP	_	_	39	case	_	_
38	the	the	DET	DEF	Definite=Def|PronType=Art	39	det	_	_
39	top	top	NOUN	SG-NOM	Number=Sing	36	nmod	_	SpaceAfter=No
40	.	.	PUNCT	Period	_	3	punct	_	_
