2 of 2 people found this helpful
Is PERIOD formatted as a number, a string or a date? Also, is your PERIOD parameter formatted as a number, string or date?
If they are numbers, try replacing both instances of FIRST() with -(ATTR([PERIOD])-[PERIOD Parameter])
If they are strings, convert them to numbers and use the above formula.
If they are dates, use -(ATTR(YEAR([PERIOD]))-YEAR([PERIOD Parameter]))
Thank you Benjamin
it works partially. If I choose 2007 (period parameter) then shows the table 2007 to 2011. (2007 = 0,00= correct).
2012 to 2015 is not shown. This is not correct.
If i choose 2010 then shows the table 2009, 2010, 2011 and 2012. (2010 = 0,00 = correct)
But why are 2013, 2014 and 2015 empty?
2009 must not be showed