If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

crosstab with 3x2 in each crossing?

Started by FixItNow, 16 Nov 2018 11:58:51 AM

Previous topic - Next topic

FixItNow

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