3 Replies Latest reply on Jun 19, 2018 3:12 PM by Hari Ankem

    How to calculate Last Year-1 Quarter on Quarter

    Helen Wang

      Hi All,


      I have been building dashboard with Profit data, QoQ, Last year QoQ.

      I want to create a calculation on Last Year-1 QoQ.


      I want to add a third line, to compute : (2018 Q3)/(2016 Q3)-1, which is Last Y-1 QoQ.


      I don't know how to do it by Add quick Table Calculation:


      This is just for Last Year QoQ:


      eg: (2018 Q1)/(2017 Q1) -1 ; (2017 Q1)/(2016 Q1) -1

      (ZN(SUM([Profit])) - LOOKUP(ZN(SUM([Profit])), -1)) / ABS(LOOKUP(ZN(SUM([Profit])), -1))


      Now I want to use:  (2018 Q1)/(2016 Q1) -1 ; (2017 Q1)/(2015 Q1) -1 ; (2016 Q1)/(2014 Q1)-1 --- as I don't have 2014.


      Thanks and best regards,