I have a matrix visual.
The row is Customer.
The column is FiscalYr.
The value is TotalSales.
I want to show the year over year difference. That is – current year sales minus previous year sales.
Is there is visual calculation that I can use to get the TotalSales value from the left hand side. For example, for year 2023, I want to do TotalSales – Left(TotalSales)
Is there a function like Left or can I achieve this using WINDOW function to peek into the left column value?