SAC - Comparing This Year v Last Year In a Table

[peersbrennanctb]

Hi 

Looking for a simple way to compare This Years Sales v Last Years Sales.

In the table I have a measure "Sales" and a date dimension "Date" in the format of YMD

I want to be able to display the variance in the table.

In the table I will have sales and date

@N1kh1l - any idea you seem to be an expert 🙂

Peers  

[peersbrennanctb]

Hi @N1kh1l 

I want it to look like this with the variance being the value in the table.

Thanks 

Peers