YOY Variance

[#1]

Hi All,

I have this table:

I want to calculate the difference between each year (i.e. 2016 vs 2015, 2015 vs 2014)

Keep in mind that the year column (employers, work locations, contracts, members) are all calculated expression and the year is a dimension.

Can anybody help?

[migueldelval]

Hi Joenunez,

If I have understood well, you need to calculate the difference between years. There aren´t problems with the calculated expression. you only need to add one expression with set analysis for each.

For example If you are Sum(Employers) -->

=(Sum({<Year={"2016"}>}Employers))-(Sum({<Year={"2015"}>}Employers))

Your result are going to be the difference between years.

Is this information correct for your problem?

Regards

Miguel del Valle