Display multiple values under single column heading in pivot table

[theyaaz]

I would like to create a pivot table that looks like this:

Pivot Table Issue - Sample.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		January	February	March	April	May	June	July	August	September	October	November	December	Total
2	Felix S
3	Yearly Salary	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00
4	Monthly Overtime	$ 50.00	$ 300.00	$ 150.00	$ 200.00	$ -	$ -	$ 500.00	$ 450.00	$ -	$ 150.00	$ 50.00	$ 250.00	$ 2,100.00
5	Monthly Salary	$ 4,716.67	$ 4,966.67	$ 4,816.67	$ 4,866.67	$ 4,666.67	$ 4,666.67	$ 5,166.67	$ 5,116.67	$ 4,666.67	$ 4,816.67	$ 4,716.67	$ 4,916.67	$ 58,100.00
6	Sarah P
7	Yearly Salary	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00
8	Monthly Overtime	$ -	$ -	$ 100.00	$ 150.00	$ -	$ -	$ -	$ 50.00	$ -	$ -	$ -	$ 50.00	$ 350.00
9	Monthly Salary	$ 5,583.33	$ 5,583.33	$ 5,683.33	$ 5,733.33	$ 5,583.33	$ 5,583.33	$ 5,583.33	$ 5,633.33	$ 5,583.33	$ 5,583.33	$ 5,583.33	$ 5,633.33	$ 67,350.00
Desired

Cell Formulas
Range	Formula
N8:N9,N4:N5	N4	=SUM(B4:M4)
B9:M9,B5:M5	B5	=(B3/12)+B4

But I cannot seem to display multiple values in rows by month. They only alternate columns like this:

Pivot Table Issue - Sample.xlsx
	A	B	C	D	E	F	G
1		Column Labels
2		January			February
3	Row Labels	Sum of Yearly Salary	Sum of Monthly Overtime	Sum of Monthly Salary	Sum of Yearly Salary	Sum of Monthly Overtime	Sum of Monthly Salary
4	Felix S	56000	50	4716.666667	56000	300	4966.666667
5	Sarah P	67000	0	5583.333333	67000	0	5583.333333
6	Grand Total	123000	50	10300	123000	300	10550
Pivot

Is this possible using a pivot table? Thank you.

 

[Georgiboy]

Think you will find this easier to do if the name is in a different cell to the function:

Name in column A
Function (Yearly salary etc...) in column B

When creating the pivot table you need to place the function part underneath the name in the rows section. Then the date/ months part in the columns.

 

[theyaaz]

Think you will find this easier to do if the name is in a different cell to the function:

Name in column A
Function (Yearly salary etc...) in column B

When creating the pivot table you need to place the function part underneath the name in the rows section. Then the date/ months part in the columns.

That worked great thank you! I used power query to unpivot my columns and got a pivot table that looks like this:

Pivot Table Issue - Sample.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
3	Sum of Value	Column Labels
4	Row Labels	January	February	March	April	May	June	July	August	September	October	November	December	Grand Total
5	Felix S	$ 60,766.67	$ 61,266.67	$ 60,966.67	$ 61,066.67	$ 60,666.67	$ 60,666.67	$ 61,666.67	$ 61,566.67	$ 60,666.67	$ 60,966.67	$ 60,766.67	$ 61,166.67	$ 732,200.00
6	Monthly Overtime	$ 50.00	$ 300.00	$ 150.00	$ 200.00	$ -	$ -	$ 500.00	$ 450.00	$ -	$ 150.00	$ 50.00	$ 250.00	$ 2,100.00
7	Monthly Salary	$ 4,716.67	$ 4,966.67	$ 4,816.67	$ 4,866.67	$ 4,666.67	$ 4,666.67	$ 5,166.67	$ 5,116.67	$ 4,666.67	$ 4,816.67	$ 4,716.67	$ 4,916.67	$ 58,100.00
8	Yearly Salary	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 56,000.00	$ 672,000.00
9	Sarah P	$ 72,583.33	$ 72,583.33	$ 72,783.33	$ 72,883.33	$ 72,583.33	$ 72,583.33	$ 72,583.33	$ 72,683.33	$ 72,583.33	$ 72,583.33	$ 72,583.33	$ 72,683.33	$ 871,700.00
10	Monthly Overtime	$ -	$ -	$ 100.00	$ 150.00	$ -	$ -	$ -	$ 50.00	$ -	$ -	$ -	$ 50.00	$ 350.00
11	Monthly Salary	$ 5,583.33	$ 5,583.33	$ 5,683.33	$ 5,733.33	$ 5,583.33	$ 5,583.33	$ 5,583.33	$ 5,633.33	$ 5,583.33	$ 5,583.33	$ 5,583.33	$ 5,633.33	$ 67,350.00
12	Yearly Salary	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 67,000.00	$ 804,000.00
13	Grand Total	$ 133,350.00	$ 133,850.00	$ 133,750.00	$ 133,950.00	$ 133,250.00	$ 133,250.00	$ 134,250.00	$ 134,250.00	$ 133,250.00	$ 133,550.00	$ 133,350.00	$ 133,850.00	$ 1,603,900.00
Sheet8

 

[Georgiboy]

Looks perfect