averages in pivot tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The pivot table in Excel allows you to show the grand totals for rows and
columns, but can it also display averages for rows and columns in the same
manner? If I set a months field in the column, for example, then the pivot
table will give monthly totals for revenue. Can it also display averages in
the same way?
 
You can change the summary function that's used in the data field, or
add another copy of the revenue field to the data area.

Right-click on a cell in the new revenue field, and choose Field Settings
From the Summarize by list, select Average
Click OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Pivot table Average with [h]:mm format 5
Pivot table grand total location 1
Average of % in pivot table 1
multiple subtotals in pivot table 1
Referencing a pivot tables Grand Totals Column 1
Pivot Table Column Totals - XL2003 5
Pivot Table - 3

Back
Top