Columns are Months (1 to 12).
Rows are employee ID, name, hire date, Term date.
In the cross tab, I can create 6 subrows (hours worked, hours billed, percentage hours billed, revenue, cost, gross profit).
Or I can create it as 6 subcolumns.
How can I have it show up:
1 | 2 | 3
Employee A - worked1 | billed1 | %1 | worked2 | billed2 | %2
(employeeA)- revenue1| cost1 | Profit1 |revenue2| cost2 | Profit2
Employee B - worked1 | billed1 | %1 | worked2 | billed2 | %2
(employeeB)- revenue1| cost1 | Profit1 |revenue2| cost2 | Profit2
i.e., in each crosstab area, I want a 3 wide by two high matrix of the six values for the employee/time period.
Or am I trying to sail into the wind?
Thanks
Pau