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
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