Compare Crosstab Columns

[MHurdatADP]

I want to compare overtime hours to regular hours; overtime earnings to regular earnings. I have columns for OT hours and REG hours, earnings as well. Can I compare two columns in Crosstab? Or must I use a derived field? Problem with a derived field is that I get no rows, because OT hours(earnings) and REG hours (earnings) are in different row numbers.

 

[CharlesCook]

You can use a calculated field in a crosstab. It is basicly a macro where you can mess with the fields that are in the crosstab.

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining