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