Hi @Mardcp
recently i did something like
periodOverPeriodDifference(sum(ifelse({date_ordered}>=parseDate(concat(toString(${ComparisonYear}),"/","01","/","01"),"yyyy/MM/dd") AND {date_ordered} <= parseDate(concat(toString(${ComparisonYear}),"/",toString(extract("MM",${ReportingDate})),"/",toString(extract("DD",${ReportingDate})),"yyyy/MM/dd")),measure,0)), {date_ordered}, WEEK,53)*-1,
to show the PY data on the same dates as the selected year.
so green is the current year and gray the prev year data (on the same date)
that way i can filter
BR