Horizontal Pivot Table

[mar4jc]

Hello,
I'd like to use a pivot table to summarize multiple dates worth of info, but it seems I can only list data vertically under each row field.

For instance, here's what I'd like to see:

Avg Avg Avg
Employee # Sales # Calls # Appts
123 45 123 10
345 34 23 13

Where the Avg is the average value over the course of 4 days worth of data.

Here's what I get:

Employee
123 Avg # Sales 45
Avg # Calls 123
Avg # Appts 10

345 Avg # Sales 34
Avg # Calls 23
Avg # Appts 13

How can I list my values across instead of as a horizontal list. Any time I try to add column headers, I get a ridiculously long pivot table with lots of entries across. Please help!
Thanks,
mar4JC

 

[Mark W.]

Right-click on the Data field button and choose Order | Move to Column from the popup menu to get the results shown on the right below...

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Employee	#Sales	#Calls	#Appts		Employee	Data	Total			Data
2	123	45	123	10		123	Averageof#Sales	45		Employee	Averageof#Sales	Averageof#Calls	Averageof#Appts
3	345	34	23	13			Averageof#Calls	123		123	45	123	10
4							Averageof#Appts	10		345	34	23	13
5						345	Averageof#Sales	34		GrandTotal	39.5	73	11.5
6							Averageof#Calls	23
7							Averageof#Appts	13
8						TotalAverageof#Sales		39.5
9						TotalAverageof#Calls		73
10						TotalAverageof#Appts		11.5
11
Sheet1

 

[mar4jc]

Thanks for the tip. I tried that but did not receive the Move to Column option. The only options I get are: move down or move to end, which changes the order in the vertical list.

Any other thoughts?
Thanks!

 

[Mark W.]

I can't tell from you original posting how your PivotTable is configured. I made my best guess, but it must not be like yours. It would be best if you used HtmlMaker to post an image of the worksheet that contains your PivotTable.

 

[mar4jc]

Hello,
I've pasted a sample pivot table here:

Book1
	A	B	C	D
3	Employee	Data	Total
4	7844	Average of Appt	0
5		Average of Sales	1.25
6		Average of Calls	1.25
7	14053	Average of Appt	0
8		Average of Sales	0.25
9		Average of Calls	0.25
10	15703	Average of Appt	0
11		Average of Sales	0
12		Average of Calls	0
13	21398	Average of Appt	0
14		Average of Sales	0
15		Average of Calls	0
16	21571	Average of Appt	0
17		Average of Sales	0
18		Average of Calls	0
19	21823	Average of Appt	0
20		Average of Sales	0
21		Average of Calls	0
22	21956	Average of Appt	0
23		Average of Sales	0.25
24		Average of Calls	0.25
...

I'm trying to get the data to display horizontally instead of vertically, while leaving the employee info on the left side. I've tried to change the order, but the options are "grayed out", so I can't chose the options you have suggested.
Thanks,
mar4JC

 

[Mark W.]

Drag the Data field button to where the Total column is and release.

 

[mar4jc]

Thanks Mark!
Dragging the "Data" Field over to the Totals column worked like a charm!

Thanks again!
- mar4jc