Add additional columns to cross-tab

[Janezz]

Hi,

I have created cross-tab with one row and one column. Row displays employees and column displays customers. Summary is sum of number of visits for each employee at each customer. There are also column and row grand totals in the cross-tab. Now I need to upgrade this report with the following:
I need two additional columns to the right of the row grand totals. First column will display number of working days for each row (employee) with column grand total, the second column will display quotient between the first additional column (working days for each employee) and each row grand total in the cross-tab (sum of visits at the customers for each employee).
Is it possible to do this?
If this is not possible this way is there any other way I can achieve this?

Regards
Janez

 

[kenhamady]

You can't directly add columns to a cross-tab. If the number of columns was fixed you could add another cross tab to the right of the original, but this is rarely workable. Could you pivot this and do 2 more rows instead of more columns? That might make adding a second cross-tab more feasable.

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/

- TEK2(AT)kenhamady.com