Examples
Given the following pivot table (titled Student Grades Pivot):
A
B
C
1
Name
Class
Grade (Average)
2
Student 1
91
3
94
4
82.5
5
Student 1 Total
89.17
6
Student 2
7
91.5
8
9
Student 2 Total
92.33
10
Grand Total
90.75
=GETPIVOTDATA(Student Grades Pivot::$C$1,Student Grades Pivot::$C$2), returns 90.75, the average grade for Students 1 and 2.
=GETPIVOTDATA(Student Grades Pivot::$C$1,Student Grades Pivot::$C$2, "Name", "Student 1"), returns approximately 89.17, the average grade for Student 1.
=GETPIVOTDATA(Student Grades Pivot::$C$1,Student Grades Pivot::$C$2, "Name", "Student 2", "Class", 1) returns 94, the average grade earned by Student 2 in Class 1.