I am trying to find the dollar variance between two quarters. When I have my date field in months in a pivot, I can easily use the “to_date” function in combination with pivot_where to calculate the variance between two months. However, when I go to roll this up to the quarter, it seems like the “to_date” function does not recognize quarters. Help resolving this would be much appreciated. I am not sure if I need to use another function?
pivot_where(
(to_date("2022-Q2")=${MYTABLE.report_quarter}),${REVENUE})