Comparing Rolling 12 months of current year to previous year.
Hi, need help with a comparison of rolling 12 months of current and previous year. The comparison shall be in the series chart. CASE WHEN YTD_Period = 'Current YTD' AND 'Date' BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 12 MONTH) AND DATE_ADD(CURRENT_DATE(), INTERVAL 3 MONTH) THEN 'Rolling 12 Months' WHEN YTD_Period = 'SPLY…
