hard20 pts · first answer countsexcelpivot-tablesstatistics
Grand total of an average pivot
A pivot shows Average of Sales by region. East has 9 rows averaging 100 and West has 1 row of 200. What does the Grand Total row show?
A pivot shows Average of Sales by region. East has 9 rows averaging 100 and West has 1 row of 200. What does the Grand Total row show?