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

       

      Thanks,

      Joshi