Excel 2016 (Windows) 64 bit F G H I J K L M 105 PivotError Overheads GrossSalary Admin #REF! 108 109 Division CostType Function Sum of Oct-15 Sum of Nov-15 Sum of Dec-15 Sum of Jan-16 110 Admin GrossSalary Overheads 1,463 2,330 2,400 2,400 111 GrossSalary Total 1,463 2,330 2,400 2,400 112 Overtime Overheads 0 0 0 0 113 Overtime Total 0 0 0 0 114 Headcount Overheads 1 2 2 2 115 Headcount Total 1 2 2 2 Payroll Worksheet Formulas Cell Formula J105 =+GETPIVOTDATA("[Measures].["&J109&"]",$G$109,"[Table4 1].[Function]","[Table4 1].[Function].&[Overheads]","[Table4 1].[CostType]","[Table4 1].[CostType].&[GrossSalary]","[Table4 1].[Division]","[Table4 1].[Division].&[Admin]")

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Power Pivot Reference Error

Excel 2016 (Windows) 64 bit
	F	G	H	I	J	K	L	M
105	PivotError	Overheads	GrossSalary	Admin	#REF!
108
109		Division	CostType	Function	Sum of Oct-15	Sum of Nov-15	Sum of Dec-15	Sum of Jan-16
110		Admin	GrossSalary	Overheads	1,463	2,330	2,400	2,400
111			GrossSalary Total		1,463	2,330	2,400	2,400
112			Overtime	Overheads	0	0	0	0
113			Overtime Total		0	0	0	0
114			Headcount	Overheads	1	2	2	2
115			Headcount Total		1	2	2	2
Payroll


Worksheet Formulas
Cell	Formula
J105	=+GETPIVOTDATA("[Measures].["&J109&"]",$G$109,"[Table4 1].[Function]","[Table4 1].[Function].&[Overheads]","[Table4 1].[CostType]","[Table4 1].[CostType].&[GrossSalary]","[Table4 1].[Division]","[Table4 1].[Division].&[Admin]")