6 Replies Latest reply: Mar 19, 2017 11:53 AM by Sunny Talwar RSS

    Dicrepancy in Total of Pivot table

    Saniya Shaikh

      Hi,

       

      I have a chart where the Sum of values(non zeros) or sum of line items is 200 whereas i am getting the total sum as 210, how shall i rectify or trouble shoot this issue??

       

      Note:-- It is a Pivot table ,there are no filters or selections or triggers applied on the chart and the value of the expression in text box also evaluates to 250 and not 200.

       

      I am attaching an excel file for your better understanding.(Data of the entire chart is copied to the table)

       

       

       

      Regards,

      Saniya