Crosstab calculation

[isamu96]

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%

 

[Madawc]

Since no one has answered, it seems likely that Crosstab simply can't do that.

You can get the same result using a Mock-Crosstab. Use SEARCH to find details of what a Mock-Crosstab is, if you don't know already.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP