This should be pretty basic but I cannot figure it out. I have a cross tab that is showing data in columns. Because the data is from two years, I have a 2009 column, a 2010 column, and a total column. I need a fourth column with the cell for the current row under 2009 subtracted from 2010, like this:

           2009        2010           total        difference
item 1     5              5                 10            0
item 2     5              0                   5            -5
item 3     5               10              15            5

How do I create the difference column?

I have tried using a calculated member, or changing my summary options somehow...it's not doing the math for me and I'm at a loss at this point.


Edited by black27696 - 23 Feb 2011 at 5:31pm