8 Replies Latest reply: Jun 2, 2014 2:54 AM by Tresesco B RSS

    Pivot table avrage calculation

    Amit Saini

      Hi Folks ,

       

      I'm using pivot table as mentioned below:

       

       

      Here subtotal at the bottom is is incorrect , I was looking for option in my table as below for Total mode please see below . but looks like it is disabled . Kindly help me how to get correct total or average at bottom .

       

       

       

      Thanks,

      AS