2 Replies Latest reply: Oct 29, 2015 5:47 AM by Sohini Bhattacharyya RSS

    Error in total values in Pivot table

    Sohini Bhattacharyya

      Hello,

      I am trying to create a simple expression in Pivot table.

       

      Unit Value:

      sum(total_sales)/sum(total_quantity)

      When I select any one month it shows correct result. But in case of more than one month selection, the total amount is incorrect. However, the figures for individual month are correct.

      For example: For Aug, Unit Value is 2034.81

                          For Sep, Unit Value is 1872.28

      Total amount coming is 1949.99

       

      Could you please help on how to resolve this.