Hi All,
Below is my report which makes use of pivot view.
The average call column aggregation rule in pivot measures is set to Average, but the grand total seems to displays incorrect values.
I have also set this option in both place pivot table and in metric aggregation formula and also try server complex aggregate but not same problem facing.
Average if computed should be (103+157+92+139+108+176) /6 = 129
but the report shows avg value as 123 which is incorrect.
Can you please suggest me what could be wrong?
The average call column is a calculated column. does this make any change in the aggregation behavior.
The tag <ReportAggregateEnabled>true</ReportAggregateEnabled>
is also present in the instanceconfig file.
Region | Country | State Code | Average call |
| Asia | China | C0009 | 103 |
| C0010 | 157 |
| C0011 | 92 |
| C0012 | 139 |
| C0013 | 108 |
| C0014 | 176 |
| Grand Total | 123 |
Please help me. we are stuck.