Hi Aakashsp,
Please see if the following solution from Jesse on a similar post can be adapted for your use case:
Last 12 months: ifelse(dateDiff({order_date},now(),"MM") <= 12, sales, 0)
Last 13-24 months: ifelse(dateDiff({order_date},now(),"MM") <= 24 AND dateDiff({order_date},now(),"MM") >12, sales, 0)
YoY %: sum(Last 12 Months) / sum(Last 13-24 months) - 1
Similar post: How to calculate YOY % through certain date?
Learning Center: Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)
If the above does not work, please send me an email with your sample data and calculation in MS Excel. Include a sheet with your calculated fields/formulas in QS.
Sincerely,
Alex
drpeter@amazon.com