4 Replies Latest reply on Feb 17, 2015 10:49 PM by Christian Berg

    Average Aggregation rule showing incorrect values in grand totals

    user8697129

      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

      CountryState CodeAverage call
      AsiaChinaC0009103
      C0010157
      C001192
      C0012139
      C0013108
      C0014176
      Grand Total123

       

       

       

      Please help me. we are stuck.