Hi I have a cross tab that has the months (@monthnames) of the year as the row and the years(ORDER_DT) as the columns for sales figures (SUM of ORDER_TOT), now I want to show the difference for each month/year - for example:
2011 2012 Difference
January 50000 35000 -15000
Feb 75000 85000 10000
March 100000 165000 65000
I can't figure out what formula to use to get the difference between the two??? How do I get it to show the difference???? Thanks
2011 2012 Difference
January 50000 35000 -15000
Feb 75000 85000 10000
March 100000 165000 65000
I can't figure out what formula to use to get the difference between the two??? How do I get it to show the difference???? Thanks