How can I get a difference column in my crosstab?
This is a simple report at this point, but I want to show the difference between the two years. This is what the report looks like now. It is adding the two years, but I want to show the difference between the two.
FY2012 FY2013
GL#105320100 $29,947.15 $13,108.64 $43,055.79
Thank you
Are you using a dimensional package or a relational package? If it's a dimensional package, simply add a query calculation with an expression that subtracts the FY2012 member from the FY2013 member. For a relational package, you will need to get rather more clever. You will need separate calcs for each FY with an expression such as
if ([Year item] = 'FY2012') then ([Your measure value]) else (0)
if ([Year item] = 'FY2013') then ([Your measure value]) else (0)
Then subtract one from the other in your difference calculation
Cheers!
MF.
Thank you for the reply, however there is a prompt page which prompts the user to pick more than one fiscal year. So I think I would have to create quite a few if statements.
This seems like it would be an easy one. The last column is produced automatically as addition. Seems to me that I could just change the math.... :'(
This is not a matter of 'simply' changing the math. Summarizing data can be a standard function as it involves selecting a single range to work upon. Calculating a difference requires input of 2 values, which requires writing an expression as pointed out..
You can define a more generic calculation if you use the 'year' input parameter to work against