4 Replies Latest reply: Apr 18, 2018 10:10 PM by Yusuf Rawat 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