Can someone please tell me what I'm doing wrong? I have created a pivot table based on the following data for each month over a six-month period: Month, Impressions, Clics, Joins, Acceptation Rate.

I would like to display in a separate column the number of Valid Joins, which is JoinsxAcceptation Rate. So I created a new calculated field with the following formula: Joins*Acceptation Rate.

This calculated field works well for showing the valid joins for each month but my problem is that, at the bottom of the Pivot Table, the "Total Sum of Valid joins" row that the Pivot Table generates automatically is not properly calculating the sum of the values in the calculated field. It says 15253 instead of 1387 (=Total Joins * Average Acceptation Rate = 1508*92%)

Any suggestions? Any help would be greatly appreciated! Sylvain

closed as off topic by Gnoupi, BinaryMisfit Jan 27 '10 at 21:33

Questions on Super User are expected to relate to computer software or computer hardware within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here. If this question can be reworded to fit the rules in the help center, please edit the question.

migrated from stackoverflow.com Dec 27 '09 at 0:33

This question came from our site for professional and enthusiast programmers.

  • Original poster never claimed this question back, voting to close as no longer relevant. – Gnoupi Jan 27 '10 at 14:47
1    |      100 | 90,0% |  90
2    |      900 | 10,0% |  90
total|     1000 | 50,0% | 500 calculated using average rate
total|     1000 | 18,0% | 180 calculated DERIVATING average rate

It is obvious that Total Valid Joins <> Total Joins * <simple> Average Rate! Indeed, Valid Joins = Total Joins * <weighted> Average Rate!