Compared to a reference year

[KIdriss]

Hello,

I would like to know how to compare a value of a year compared to a reference year. The reference year is 2000

I create a Line chart.

- Dimension: colDate.autoCalendar.Year

- Measure:  comparison with the reference year

I added the code below in Measure but I get 0 for each years. 

(
	(
  		Sum(colValue) - Sum({<[colDate.autoCalendar.Year] = {"2000"}>} colValue)
	) / Sum({<[colDate.autoCalendar.Year] = {"2000"}>} colValue)
) * 100

[jochem_zw · Accepted solution]

Try something like this:

( ( Sum(colValue) - Sum(Total {<[colDate.autoCalendar.Year] = {"2000"}>} colValue))

/

Sum(Total {<[colDate.autoCalendar.Year] = {"2000"}>} traf_aer_pax)) * 100

[KIdriss]

Hello, thank for your help.