Damian What you could do is create a separate custom measures in your report to accumulate the expenditure for each FY2008_09, FY2009_10, FY2010_11 by filtering the each year in the custom measure. For example: IF Year = FY2008_09 THEN Expense (Measure) ELSE 0. Then aggregate (SUM) the these measures TOT_ FY2008_09, TOT_FY2009_10 and TOT_FY2010_11. All you need next is a aggravated calculation for the percentage change for each year you are comparing. for example: IF (TOT_ FY2008_09 = 0) AND (TOT_FY2009_10 = 0) THEN 0 ELSE IF (TOT_ FY2008_09 = 0) AND (TOT_FY2009_10 > 0) THEN 1 /* 100% increase */ ELSE IF (TOT_ FY2008_09 > 0) AND (TOT_FY2009_10 = 0) THEN -1 /* -100% increase */ ELSE (TOT_FY2009_10 - TOT_ FY2008_09 > 0) / TOT_ FY2008_09 > 0. ******* TOT_ FY2008_09 = 0 and TOT_FY2009_10 = 0 then aggravated calculation measure = 0 TOT_ FY2008_09 = 0 and TOT_FY2009_10 > 0 then aggravated calculation measure = 1 TOT_ FY2008_09 > 0 and TOT_FY2009_10 = 0 then aggravated calculation measure = -1 TOT_ FY2008_09 = 100 and TOT_FY2009_10 = 110 then aggravated calculation measure = 0.1 (110 - 100) / 100 = 0.1 or 10% If you prefer whole numbers e.g. 1 = 100 then change 1 to 100, -1 to -100 and calculation (TOT_FY2009_10 - TOT_ FY2008_09 > 0) / TOT_ FY2008_09 * 100 so you final display has no percentage symbol. ******* Then format the aggravated calculation measure to % with the required decimals. I have used this in list objects with square bullets that change colour depending on the percentage change, for example green = change less than 0, yellow less than plus 10% change and Red = over 10% change. I am interested if there are any other solutions. Peter Conroy
... View more