Missing Grand Total for a Calculated Field in a Pivot Table


G

Guest

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?
 
Ad

Advertisements


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

Top