Calculated Fields in Pivot Table

B

Ben B.

In Excel 2007 Is it possible to create a calculated field using the sum of an
numeric field divided by the sum of a text? My table has a list of products
(text) which I have counted and the sum of the associated revenue (numeric).
Currently I calculate an the average outside the table. However, when a new
product is introduced the grand total formula is eliminated. When I added a
calculated field the results are #DIV/0!.

Thanks.
 
E

Eduardo

Hi,
If you go to your PT totals, right click in the mouse, field settings, then
choose average
Hope this help
 
B

Ben B.

Eduardo,

Thanks. It helped but in an unanticipated way. I originally set the format
of the calculated field to average but it did not change anything. Your post
however got me thinking about adding the revenue field in a second time to
the table and changing that format to average which gives me exactly what I
need.

Thanks again.
 

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
Calculated Fields in Pivot Tables 5
Pivot Table Field based on two data area fields 3
How to ignore a column of numbers in Grand Total for rows 1
2007 Pivot table Calculated field misbehaving 1
Pivot table calculated field Count(field) / sum(field) 0
calculated fields in pivot tables 1
Pivot Table Calculated Field using Grand Total 3

Top