manual cross tabs 1

[Lhuffst]

Trying my luck at a manual cross tab in XI (it works in a cross tab but am trying to expand my limited knowledge) and need some clarification. I read a post that gives some steps but I haven't been successful in reproducing it.

I am trying to return counts for each employee based on dates so I

1. Created a group on datefield
2. created a group on employee field
In the employee group made a formula:

if {Command.SHORTTITLE} = "Amends" then
{Command.DESC_COUNT}

I don't receive any errors but get a zero for display.
If I put the cnt field by itself in the employee group, it displays the correct count but I think I just got lucky.

I also tried a formula: if {Command.SHORTTITLE} = "Amends" then
Sum({Command.DESC_COUNT}, {@EmpName})

I don't understand how to make a column for each shorttitle per person. Can someone tell me what I'm doing wrong? What I expected is:
date
shorttitle1 shorttitle2
emp1 1 2
emp2 2 3

Thanks

 

[IanWaterman]

In details add formula

@amends
if {Command.SHORTTITLE} = "Amends" then
1 else 0

Suppress detail line

Then in relevant gouup add a "Sum" summary of this formula which will effective be a count.

Repeat for other columns.

Ian

 

[Lhuffst]

That works great. thanks