This year % over multiple previous years

[cogusergirl]

using transformer cube

trying to measure previous ytd to current ytd to create a % growth

years        measure       measure/ytd current year

2008            10                         4% 
2009            9                           3% 
2010            10                         4% 
2011            8                           2.5% 
2012            10                         0% 

however since year is in the rows of the crosstab it keeps giving me

years        measure       measure/ytd current year

2008            10                         
2009            9                             
2010            10                         
2011            8                             
2012            10                         0% 


since 2012 is the only year that YTD relates to

is it possible to calculate the growth on past years against ytd for this year

[Grim]

Calculated categories and "percent-growth" function.

http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_cogtr.10.1.0.doc%2Fug_cogtr_id4098CreateCalculatedCategories.html