6 Replies Latest reply: Jan 26, 2017 9:37 AM by Sunny Talwar RSS

    Calculating Monthly Variance in Pivot

    John Hillock

      I have a pivot table in which I'm trying to calculate a yearly average in a column, but having the month as a dimension is throwing it off. An idea for the final output would be like the table below. Any thoughts?

       

      MonthCostYear AverageVariance

      Jan

      10

      21-11
      Feb1521-6
      Mar2021-1
      Apr1521-6
      May521-16
      Jun452124
      Jul30219
      Aug2021-1
      Sep1521-6
      Oct30219
      Nov2021-1
      Dec25214