3 Replies Latest reply: Mar 30, 2017 6:50 AM by Sunny Talwar RSS

    QoQ variance calculation

    joshi Babu Are

      hi all,

       

      i want to calculate QoQ Variance in Pivot Table .

       

      if no year is selected it should show Current year(2017) data .

       

      if no year selected its showing correct values  for 2017 Q1 But remaining quarters its showing blank.

       

      i want to display QoQ variance for remaining quarters as well

       

      How to show QoQ Variance for Q2,Q3,Q4.

       

      please find the attached screen shot results for 2017 Q2,Q3,Q4

       

       

      Formula:Q2 Amount-Q1Amount/Q1 Amount

       

      Thanks,

      Joshi