calculations in cross tab

[Erl072408]

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

[MFGF]

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.

[Erl072408]

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.... :'(

[blom0344]

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