Time Summary: MoM, QoQ, and YoY on the same line item
I am trying to create a "% growth" line item, where this line should be able to represent MoM, QoQ, and YoY on the same line (with or without the use of working line items)
As time summary does not allow us to use OFFSET or PREVIOUS, what should be the best workaround for this?
(Note: with the creation of new working line item as previous, QoQ and YoY still does not work because it will take previous "month" instead of "quarter")
In the line item that I would like to build, I want it to be as followings:
at %growth M3: = M3/M2-1 i.e. 7/8-1
%growth Q2: = Q2/Q1-1 i.e. 4/7-1
%growth Y2018 = Y2018/Y2017-1 i.e. 30/20-1,
in the same %growth line item.
Does anyone has any suggestion to this? Any response is greatly appreciated. Thank you.