Good day,
I want to add an embedded formula to a pivot table,
for the below example I want the field "Score" with value 4 + field "Score" value 5 / total Score
(Score[4] + score[5]) / Score
ActiveSheet.PivotTables("PivotTable1").PivotFields("Overall Satisfaction").PivotItems("4")
+
ActiveSheet.PivotTables("PivotTable1").PivotFields("Overall Satisfaction").PivotItems("5")
/
ActiveSheet.PivotTables("PivotTable1").PivotFields("Overall Satisfaction")
int he example below ...
Agent X% = 40 + 70 / 172 = 64%
Score
Agent 1 2 3 4 5
X 36 11 15 40 70
Y 10 9 10 12 69
Z 58 10 9 19 44
I can use the field =GETPIVOTDATA("Score",$B$4,"Agent","X","Month",1,"Week num",1,"Score",4)
or simply just use (F8+G8)/H8, however wanted to see if this could be done with an embedded formula,
thanks for your time,
Bookmarks