I have a query where I have to calculate the growth between, let's say, 2006 training hours and 2005 training hours. If 2006 TH was 20 h., and 2005 TH was 11 h., growth would be 81,82%.
I can easily calculate that with two restricted key figures (one for each year) and using Percentage Variance in a formula (2005 % 2006). My problem is that I have to calculate the growth between many different KF's, so the final query looks like a mess to mantain (a total of 30+ restricted KF's and formulas), and is not as nice looking in excel as a regular query with its automatic totals.
Is there an easy way to do this? I have tried using the "Calculate result as variance" property, adding the year as a column and not restricting the ratios, but it doesn't seem to work (in this case result would be 40,5 which isn't the variance % between 2005 and 2006, or vice versa)
Thanks for any help,