In Qlik Sense how would you create measure to show ThisYear sales rev and LastYrsales rev

[#1]

I would like to show in a table the Regional sales for ThisYr(2014) and LastYr(2013). Plus a Variance  at the end

Region Name	2013 SALES	2014 SALES
Berkshire	$100	$200
Bucks	$50	$150
Bedfordshire	$400	$300

The data is stored by transaction date in an Xls sheet, which I have been able to convert to via the Load script to Month, Quarter and Year.  In Qlik View it appears you are able to use variables to achieve this.  How would this problem be approached in Qlik sense.

Thanks

[Michael_Tarallo]

Hello Ankit - I will bump this topic - can someone assist Ankit?

In the mean-time, I believe you would need to pivot this data first into a de-normalized table. Take a look at this video to get an idea: Qlik Sense 3.1 - Using Unpivot (video)

Mike