Crosstab problem - add new column for count only 1

[sds786]

Hi,
I am using Crystal 11.5 with Oracle 10.00 /Universe I have a crosstab report and there is problem in adding new column at the end of the report to show the total count of all the values which are added in the column total,

I have Employee Id as row and their respective monthly earnings as column, I need Total employee earning as well as the count of the week, If I add new column in the summary field of the crosstab expert for count, it shows in all the rows for each employee and add a 2nd row in column total, I can suppress the details counts for each month but the total count appears in the same column of the TOTAL and I need just a new column before or after the TOTAL column which shows the count of weeks having earnings i.e.

Empl ID - Jan, Feb, Mar. Total Count
123 500 400 600 1500 3
456 400 700 - 1100 2


Thanks for the help

 

[lbass]

Add the count as your second summary field and then go to the customize style tab->summarized fields->horizontal->show labels. Then in design mode, suppress the count and label for the inner cells and resize the count column for the inner cells to minimize the width.

-LB

 

[sds786]

Super - Thank you so much LB