Spreadsheet: 149141d1333717592-pivot-table-grand-total-average-in-a-formula-sample
Sheet: Sheet1

Data | A | B | C
March | 1 | 1 | 1
February | 1 | 1 | 1 |  |  | Values
March | 1 | 0.956 | 1 |  | Row Labels | Average of A | Average of B | Average of C
April | 1 | 0.956 | 1 |  | January | 1 | 0.99175 | 1
May | 1 | 0.956 | 1 |  | February | 1 | 0.9975555555555555 | 1
June | 0.956 | 0.956 | 1 |  | March | 0.9905263157894737 | 0.9953684210526316 | 0.9863157894736844
July | 1 | 0.956 | 1 |  | April | 0.9926666666666666 | 0.9877777777777776 | 1
August | 1 | 0.956 | 1 |  | May | 0.978 | 0.9902222222222221 | 0.98
September | 1 | 0.956 | 1 |  | June | 0.9789473684210526 | 0.9953684210526316 | 0.9863157894736841
October | 1 | 0.956 | 1 |  | July | 1 | 0.9951111111111111 | 0.9926666666666666
November | 1 | 0.956 | 1 |  | August | 0.9802777777777776 | 0.976861111111111 | 0.9905555555555554
December | 1 | 0.956 | 1 |  | September | 0.9948888888888887 | 0.9914444444444445 | 0.9882222222222222
June | 0.956 | 0.956 | 1 |  | October | 0.9816470588235293 | 0.9974117647058823 | 0.9952941176470587
February | 1 | 0.956 | 1 |  | November | 0.9925882352941175 | 0.9712941176470586 | 0.9899999999999999
March | 1 | 0.956 | 1 |  | December | 1 | 0.9974117647058823 | 1
April | 1 | 0.956 | 1 |  | Grand Total | 0.9906431924882627 | 0.9906924882629106 | 0.9922816901408449
May | 0.868 | 1 | 1
June | 1 | 1 | 1
July | 1 | 0.956 | 1
August | 0.956 | 1 | 1
September | 1 | 1 | 1
October | 1 | 1 | 1
November | 1 | 0.82 | 1
December | 1 | 1 | 1
January | 1 | 1 | 1
February | 1 | 1 | 1
March | 1 | 1 | 1
April | 1 | 1 | 1
May | 0.868 | 0.868 | 0.82
June | 1 | 1 | 1
July | 1 | 1 | 1
August | 1 | 1 | 1
September | 0.956 | 0.89 | 1
October | 1 | 1 | 1
November | 1 | 1 | 1
December | 1 | 1 | 1
January | 1 | 1 | 1
February | 1 | 1 | 1
March | 1 | 1 | 1
April | 0.868 | 1 | 1
May | 1 | 1 | 1
June | 0.952 | 1 | 0.92
July | 1 | 1 | 1
August | 1 | 1 | 1
September | 1 | 1 | 1
October | 1 | 1 | 1
November | 0.8739999999999999 | 0.868 | 0.8299999999999998
December | 1 | 1 | 1
January | 1 | 1 | 1
February | 1 | 1 | 1
March | 1 | 1 | 1
April | 1 | 1 | 1
May | 1 | 1 | 1
June | 1 | 1 | 1
July | 1 | 1 | 0.868
August | 1 | 1 | 1
September | 1 | 1 | 1
October | 1 | 1 | 1
November | 1 | 0.868 | 1
December | 1 | 1 | 1
January | 1 | 1 | 1
February | 1 | 1 | 1
March | 0.868 | 1 | 0.82
April | 1 | 0.868 | 1
May | 1 | 1 | 1
June | 1 | 1 | 1
July | 1 | 1 | 1
August | 0.8739999999999999 | 0.9999999999999998 | 0.8299999999999998
September | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
October | 0.9999999999999994 | 1 | 0.9999999999999991
November | 0.9999999999999999 | 0.9999999999999998 | 1
December | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
January | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
February | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
March | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
April | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
May | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
June | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
July | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
August | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
September | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
October | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
November | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
December | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
January | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
February | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
March | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
April | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
May | 1 | 1 | 1
June | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
July | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
August | 0.9999999999999994 | 1 | 0.9999999999999991
September | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
October | 0.868 | 0.9999999999999998 | 0.9999999999999999
November | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
December | 0.9999999999999999 | 0.9999999999999998 | 1
January | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
February | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
March | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
April | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
May | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
June | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
July | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
August | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
September | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
October | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
November | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
December | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
January | 0.9999999999999998 | 0.868 | 0.9999999999999999
February | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
March | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
April | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
May | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
June | 0.868 | 0.9999999999999998 | 0.9999999999999999
July | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
August | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
September | 0.9519999999999998 | 0.9999999999999998 | 0.9199999999999999
October | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
November | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
December | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
January | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
February | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
March | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
April | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
May | 0.8679999999999999 | 0.9999999999999998 | 0.8199999999999998
June | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
July | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
August | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
September | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
October | 0.868 | 0.9999999999999998 | 0.9999999999999999
November | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
December | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
January | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
February | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
March | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
April | 0.9999999999999994 | 1 | 0.9999999999999991
May | 0.9999999999999996 | 1 | 0.9999999999999991
June | 0.8679999999999999 | 0.9999999999999998 | 0.8199999999999998
July | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
August | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
September | 0.9999999999999998 | 0.9999999999999998 | 0.868
October | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
November | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
December | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
January | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
February | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
March | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
April | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
May | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
June | 0.9999999999999999 | 1 | 0.9999999999999999
July | 0.9999999999999994 | 1 | 0.9999999999999991
August | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
September | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
October | 0.9519999999999998 | 0.9999999999999998 | 0.9199999999999999
November | 0.9999999999999999 | 1 | 0.9999999999999999
December | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
January | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
February | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
March | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
April | 0.9999999999999996 | 1 | 0.9999999999999991
May | 0.9999999999999994 | 1 | 0.9999999999999991
June | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
July | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
August | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
September | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
October | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
November | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
December | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
January | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
February | 0.9999999999999994 | 1 | 0.9999999999999991
March | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
April | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
May | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
June | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
July | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
August | 0.8149999999999997 | 0.6275 | 0.9999999999999999
September | 0.9999999999999996 | 1 | 0.9999999999999991
October | 0.9999999999999993 | 0.9999999999999998 | 0.9999999999999991
November | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
December | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
January | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
February | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
March | 0.9519999999999998 | 0.9999999999999998 | 0.9199999999999999
April | 0.9999999999999998 | 0.9999999999999999 | 0.9999999999999999
May | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
June | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
July | 1 | 1 | 0.9999999999999999
August | 1 | 1 | 0.9999999999999999
September | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
October | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
November | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
December | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
January | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
February | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
March | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
April | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
May | 0.9999999999999999 | 0.9999999999999998 | 1
June | 0.9999999999999999 | 0.9999999999999998 | 1
July | 0.9999999999999999 | 0.9999999999999998 | 1
August | 0.9999999999999999 | 0.9999999999999998 | 1
September | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
October | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
November | 0.9999999999999999 | 0.9999999999999998 | 1
December | 0.9999999999999999 | 0.9999999999999998 | 1
January | 0.9999999999999999 | 0.9999999999999998 | 1
February | 0.9999999999999999 | 0.9999999999999998 | 1
March | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
April | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
May | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
June | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
July | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
August | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999
September | 0.9999999999999998 | 0.9999999999999998 | 0.9999999999999999