praveen224
IS-IT--Management
Hello all,
I have a crosstab report that has formula for columns - which ends up being only two columns which represent the year and customer as rows. The summary field is revenue. I am trying to add a column at the end that would calculate the difference in revenue in dollars and also as a percent. Here is an example:
2008 2009
Cust1 $1000 $2000
Cust2 $1500 $1200
I would like to see:
2008 2009 Diff %
Cust1 $1000 $2000 $1000 150%
Cust2 $1500 $1200 ($300) 75%
Any help is appreciated.
Thanks
Praveen
I have a crosstab report that has formula for columns - which ends up being only two columns which represent the year and customer as rows. The summary field is revenue. I am trying to add a column at the end that would calculate the difference in revenue in dollars and also as a percent. Here is an example:
2008 2009
Cust1 $1000 $2000
Cust2 $1500 $1200
I would like to see:
2008 2009 Diff %
Cust1 $1000 $2000 $1000 150%
Cust2 $1500 $1200 ($300) 75%
Any help is appreciated.
Thanks
Praveen