Missing Grand Total for a Calculated Field in a Pivot Table

  • Thread starter Robert Hamilton
  • Start date
R

Robert Hamilton

I created a calculated field called "rate" that is equal to "Field1/Field2"
in a pivot table. The calculation displays the correct quotient in the
sub-total and individual grand total fields. However, the overall Grand
Total is always 0%. Below is an example of the problem

Group Category Jan. Feb. Mar. Grand Total
North Field1 10 15 20 35
Field2 5 10 15 30
Rate 2.0 1.5 1.3 1.67

South Field1 15 20 30 65
Field2 5 10 15 30
Rate 3.0 2.0 2.0 1.85

Grand Total (rate) 2.5 1.75 1.67 0

Can someone tell me what is going on? What can I do to replace the "0" with
the correct calculation?
 

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

How to ignore a column of numbers in Grand Total for rows 1
Assistance need to populate "GRAND TOTAl" "MSpivottable11" in Microsoft web component 0
Difference between 2 calculated fields showed as % of grand total 0
Difference between 2 calculated fields showed as % of grand total 0
Calculated Field in Pivot Table 0
pivot table, grand total no negatives 3
Data Grand Total in Pivot Table Row Area 1
SUMPRODUCT - Creating a weighted score in column with subtotals 3

Top