YoY calcuation as per multiple calculations?

[sunilchakala_ql]

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

[Anil_Babu_Samineni]

What is your YOY formula?

[sunilchakala_ql]

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.

[Anonymous]

Hi,

Perhaps this could help: Year over year comparison