Calculating index vs Year Ago
i have a calendar date column and a sales$ column. i would like to calculate sales index vs year ago. How can i do that within Beast Mode? Date: Calendar date Sales $ e.g: Sales IYA = (Sales $ on 15May2020) / (Sales $ on 15 May 2019) * 100 is there a way i can shift the date to create a (sales $YA) column?
