Adding Extra Column To Cross Tab (V9)

[aljodo]

Hi All,

I have a cross tab report that has rows showing Work Tasks and columns showing the Grade of Employee involved. It shows the Hours and Values in the body of the report.

What I need to do is add an extra total column that will show the average hourly rate for each Work Task, but I can't figure out how to do it.

E.g.:

Assistant Manager Total AveHourlyRate
Admin Hours 10 10
Value 210 210 21
Audit Hours 3 12 15
Value 63 600 663 44
Total Hours 13 12 25
Value 273 600 873

I hope this makes sense!

Is it possible using a manual cross tab? If so, how?

TIA for any help,

Alan Donaldson.

 

[aljodo]

In case anyone is interested, I got round this by creating another Cross-Tab and aligning it next to the original one.

The only problem this gives me is a gap between the 2 tables if the first one doesn't have data in each column.

Cheers,

Alan.