lookup function for YOY with drilldown

[vrajgopal]

I am trying the to create a YoY view with drilldown to quarters.

LOOKUP([ACV] ,[d/Date]=Previous("Year",1))

LOOKUP([ACV] ,[d/Date]=Current("Year"))

The above formula works if am comparing 2023 with 2022. If i want to drilldown and compare say Q1'23 with Q1'22 it does not.

Is there a way I can include quarterly calculation (LOOKUP([ACV] ,[d/Date]=Previous("Quarter",4))) in the same formula with the year??

regards

Vish

[geeta2021]

Hello Vishwanath,

You can create calculated measures with Input controls that should work.

Thanks & Regards,

Geeta

[vrajgopal]

Thanks will try an implement it.

I came with another workaround of using radio buttons and giving a yearly and quartery view