Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crosstab calculation

Status
Not open for further replies.

isamu96

Programmer
Jun 14, 2012
1
US
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%
 
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.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top