1 Reply Latest reply on Jul 30, 2018 1:50 PM by Malvika Bodh

    YoY calculation with only 2 quarters in the current year

    Malvika Bodh

      Hello,

       

      I have a dataset where I have only three quarters in the most recent year. I want to calculate YoY (cumulative three current Q's over cumulative three previous Q's) growth for the latest period compared to same three quarters in the previous year. Is there a way of doing this dynamically, such that the calculation updates if new data is added? Also, is there a way to show them cumulatively (for a year) instead of Q1 and Q2?

       

      Thank you!