i have one expression which was created on tableau "([MAT Market Units]*LOOKUP([MAT Win Rate],-1)*([MAT Unit Awareness]-LOOKUP([MAT Unit Awareness],-1)))/ [MAT Market Units]" all the fields are calculated fields, my issue is with lookup calculation in qlik sense, is there any way to do MAT number calculation but not from the current month, i need it to calculate this from previous month so i can solve the highlighted area calculation.
