Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
i am trying to calculate YoY as per multple quarters.
i am able to get the result YoY when i am selecting one quarter, but i would like to get the result when user select 2017Q4,2018Q2, then YoY resut needs to automatically calculate (2017Q4,2018Q2/2016Q4,2017Q1)-1.
let me know if any one has tried this.
Thanks
Sunil
What is your YOY formula?
I am trying to calculate as (selected quarter/ last year same quarter)-1, selected quarter and last year same quarter created by vaiable which will give values.this is working when selecting one quarter but i need to get the YoY when user selects multiple quarters.
Hi,
Perhaps this could help: Year over year comparison