Crosstab average column
Crosstab average column
(OP)
Hi all,
I know that this is probably not an original problem, but I’ll ask it anyway.
Does anyone know if it is possible to add an extra total column to a crosstab. I have a crosstab which is working perfectly for what my client wants except that they would like an average column after the grand total column on the right. This average column should be the grand total divided by the number of columns that are working days.
Does anyone know if this can be done? If I can’t do this in a crosstab then I will have to create some kind of mock crosstab that won’t be as dynamic.
Any response will be greatly appreciated.
I know that this is probably not an original problem, but I’ll ask it anyway.

Does anyone know if it is possible to add an extra total column to a crosstab. I have a crosstab which is working perfectly for what my client wants except that they would like an average column after the grand total column on the right. This average column should be the grand total divided by the number of columns that are working days.
Does anyone know if this can be done? If I can’t do this in a crosstab then I will have to create some kind of mock crosstab that won’t be as dynamic.

Any response will be greatly appreciated.

RE: Crosstab average column
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
http://www.kenhamady.com/ - tek@kenhamady.com
RE: Crosstab average column
Can you tell me if there is a way to create virtual pages if not using a crosstab.
RE: Crosstab average column
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
http://www.kenhamady.com/ - tek@kenhamady.com
RE: Crosstab average column
But thanks for your help anyway. Guess I'll have to consult my client and try and twist their arm a bit to have the average in the footer of the report.