Crosstab report - formulas

[LowellE]

I have a table that consists consists of Date, Value and Result name. I've done crosstab report on it but it is very difficult to do the math that is needed. Is there a way to convert the crosstab to a table where the column, row names would be the fields in the new table? Example:

Current table - date value result name
12/01/2002 10.0 Raw water
12/01/2002 11.0 Final water
12/02/2002 9 Secondary

New table - Raw water FinalWater Secondary
12/01/2002 10 11 9
12/02/2002 15 10 12

I have greatly simplified the tables but I hope you can get the idea.

 

[Bowne]

You could Export the report data to FoxPro, Excel, Access etc., add columns (fields) for your calculations, massage your data, and then use this new file to create your crosstab in Crystal. There may be an easier/better way to do this but it may still help you.