I am trying to create LLY(last to last year) measure in Looker. At the moment I have sales for SLS TY (January 2021) and I add SLS LY (January 2020). If I pull in the measure SLS LLY in the look, I should get the sales for January 2019. I do not have the SLS LLY field in my snowflake database but I have the SLS TY and SLS LY.
I think this is a bit complicated, but any ideas would be appreciated.