If you want the Excel PivotTable report to reflect the appearance of the PivotTable view, before you export to an Excel PivotTable report, either move all the fields out of the detail area, or hide detail data for items and cells so that the detail area is not displayed.
1	If	if	SCONJ	_	_	3	mark	_	_
2	you	you	PRON	PERS-P2	_	3	nsubj	_	_
3	want	want	VERB	PRES	Mood=Ind|Tense=Pres|VerbForm=Fin	27	advcl	_	_
4	the	the	DET	DEF	Definite=Def|PronType=Art	7	det	_	_
5	Excel	Excel	PROPN	SG-NOM	Number=Sing	7	compound	_	_
6	PivotTable	PivotTable	NOUN	SG-NOM	Number=Sing	7	compound	_	_
7	report	report	NOUN	SG-NOM	Number=Sing	3	obj	_	_
8	to	to	PART	_	_	9	mark	_	_
9	reflect	reflect	VERB	INF	VerbForm=Inf	3	xcomp	_	_
10	the	the	DET	DEF	Definite=Def|PronType=Art	11	det	_	_
11	appearance	appearance	NOUN	SG-NOM	Number=Sing	9	obj	_	_
12	of	of	ADP	_	_	15	case	_	_
13	the	the	DET	DEF	Definite=Def|PronType=Art	15	det	_	_
14	PivotTable	PivotTable	NOUN	SG-NOM	Number=Sing	15	compound	_	_
15	view	view	NOUN	SG-NOM	Number=Sing	11	nmod	_	SpaceAfter=No
16	,	,	PUNCT	Comma	_	3	punct	_	_
17	before	before	SCONJ	_	_	19	mark	_	_
18	you	you	PRON	PERS-P2	_	19	nsubj	_	_
19	export	export	VERB	PRES	Mood=Ind|Tense=Pres|VerbForm=Fin	27	advcl	_	_
20	to	to	ADP	_	_	24	case	_	_
21	an	an	DET	IND-SG	Definite=Ind|PronType=Art	24	det	_	_
22	Excel	Excel	PROPN	SG-NOM	Number=Sing	24	compound	_	_
23	PivotTable	PivotTable	NOUN	SG-NOM	Number=Sing	24	compound	_	_
24	report	report	NOUN	SG-NOM	Number=Sing	19	obl	_	SpaceAfter=No
25	,	,	PUNCT	Comma	_	19	punct	_	_
26	either	either	CCONJ	_	_	27	cc	_	_
27	move	move	VERB	IMP	Mood=Imp|VerbForm=Fin	0	root	_	_
28	all	all	DET	TOT-PL	_	29	det	_	_
29	the	the	DET	DEF	Definite=Def|PronType=Art	30	det	_	_
30	fields	field	NOUN	PL-NOM	Number=Plur	27	obj	_	_
31	out	out	ADP	_	_	35	case	_	_
32	of	of	ADP	_	_	31	fixed	_	_
33	the	the	DET	DEF	Definite=Def|PronType=Art	35	det	_	_
34	detail	detail	NOUN	SG-NOM	Number=Sing	35	compound	_	_
35	area	area	NOUN	SG-NOM	Number=Sing	27	obl	_	SpaceAfter=No
36	,	,	PUNCT	Comma	_	38	punct	_	_
37	or	or	CCONJ	_	_	38	cc	_	_
38	hide	hide	VERB	IMP	VerbForm=Inf	27	conj	_	_
39	detail	detail	NOUN	SG-NOM	Number=Sing	40	compound	_	_
40	data	data	NOUN	PL-NOM	Number=Sing	38	obj	_	_
41	for	for	ADP	_	_	42	case	_	_
42	items	item	NOUN	PL-NOM	Number=Plur	40	nmod	_	_
43	and	and	CCONJ	_	_	44	cc	_	_
44	cells	cell	NOUN	PL-NOM	Number=Plur	42	conj	_	_
45	so	so	SCONJ	_	_	52	mark	_	_
46	that	that	SCONJ	_	_	45	fixed	_	_
47	the	the	DET	DEF	Definite=Def|PronType=Art	49	det	_	_
48	detail	detail	NOUN	SG-NOM	Number=Sing	49	compound	_	_
49	area	area	NOUN	SG-NOM	Number=Sing	52	nsubj:pass	_	_
50	is	be	AUX	PRES-AUX	Mood=Ind|Number=Sing|Person=3|Tense=Pres|VerbForm=Fin	52	aux:pass	_	_
51	not	not	PART	NEG	_	52	advmod	_	_
52	displayed	display	VERB	PASS	Tense=Past|VerbForm=Part|Voice=Pass	38	advcl	_	SpaceAfter=No
53	.	.	PUNCT	Period	_	27	punct	_	_
