Cross Tab Rows

[janchan]

I need help in this cross-tab format. i need something like this in my cross-tab: (Just an Example).

Dates Branch1 Branch2
1/1/2005 Work>5 12 15
Work>8 5 2

1/2/2005 Work>5 14 21
Work>8 6 12

1/3/2005 Work>5 23 18
Work>8 5 3

Work and Branch are not hard-coded in the table. Work>x is the count of employess they work more than x hours on a day. is there a way to get a cross-tab like this? Please help.

Thanks.

-- Jan

 

[janchan]

I created a formula @Work>5:

if work_hours > 5 then EMP_ID

and @Work>8

if work_hours > 8 then EMP_ID

and used these formulas as summaries in the cross-tab. i got the results. i want to know if there is a way to display the text for each day as:

"Work>5" and "Work>8" next to the dates. sorry for not explaining this well.

 

[lbass]

Create a formula:

whilereadingrecords;
"Work>5" + chr(13)+"Work>8"

Add this to crosstab as your second row field. Then go to the customize style tab->select your date rowfield->suppress subtotals.

-LB

 

[janchan]

LB,

Thanks a lot. I figured out a way to do this.

Cross-Tab Expert - Style - Show Labels

this showed the field being summarized. i edited the text to suit my needs.

 

[lbass]

You didn't say what version you are using--it must be something higher than 8.5, as this feature is not available in the version I use.

-LB

 

[janchan]

Sorry about that. i am using Crystal XI.