Difference in crosstab

vash

Hi,

I want to have a "difference" column in a crosstab.

For example:

2009 2010 Diff
abc 555 444 111
def 300 333 -33

Is this possible???

I tried adding a derived measure to calculate the diff but it shows up like this:

2009 2010
abc 555 0 444 111
def 300 0 333 -33

Any suggestions????

Thanks,
Vash

mwilliams

Hi Vash,

You might be able to use the grand totals column to do this. Delete the total element if you don't want it and drop your own data element in there. Let me know if this works.