How do you calculate the % difference from cells in a crosstab. I can get the calculation going by using a calculated member but I can't figure out how to place it correclty in the crosstab. When I add a row it gets grouped with the Totals or with the Approved rows. I am using Crystal 2008. This is the formula I am using to calculate the % ((GridValueAt(GetRowPathIndexOf(2011.00, "Approved"), CurrentColumnIndex, CurrentSummaryIndex) - GridValueAt(GetRowPathIndexOf(2010.00, "Approved"), CurrentColumnIndex, CurrentSummaryIndex)) / GridValueAt(GetRowPathIndexOf(2010.00, "Approved"), CurrentColumnIndex, CurrentSummaryIndex)) * 100
This is what I would like it to look like.
_____________________Jan___Feb
2010___Approved_______1_____4
_______Not_Approved___3_____8
_______Total__________4_____12
2011___Approved_______3_____2
_______Not_Approved___5_____5
_______Total__________8_____7
%_increase/decrease_2010_vs_2011____Jan_____Feb
Approved__________________________200%____-50%
Not_Approved_______________________67%____-38%
Total______________________________100%____-41%
This is what I would like it to look like.
_____________________Jan___Feb
2010___Approved_______1_____4
_______Not_Approved___3_____8
_______Total__________4_____12
2011___Approved_______3_____2
_______Not_Approved___5_____5
_______Total__________8_____7
%_increase/decrease_2010_vs_2011____Jan_____Feb
Approved__________________________200%____-50%
Not_Approved_______________________67%____-38%
Total______________________________100%____-41%