Cumulative Crosstab Possible?

[OKCMikeSoll]

I have a crosstab report that shows the number of helpdesk issues resoved by group and by the age. I would like to get cumulative totals instead of the accual count of issues resolved and have it displayed as a percentage.

This is what the current report produces:
>1 Day | 1 Day | 2 Days | 3 Days | TOTAL
Group1: 5 1 3 7 16
TOTAL: 5 1 3 7 16

This is what I would like to get instead:
>1 Day | 1 Day | 2 Days | 3 Days | TOTAL
Group1: 31% 38% 56% 100%
TOTAL: 31% 38% 56% 100%

Please let me know if I need to provide more information and thank you in advance.

CR v.9

 

[lbass]

I think you'd have to create a manual crosstab by making detail level formulas like:

//{@<1 Day}:
if datediff("h",{table.datereported},{date.resolved}) < 24 then 1

//{@<=1 Day}:
if datediff("d",{table.datereported},{date.resolved}) <= 1 then 1

//{@<=2 Days}:
if datediff("d",{table.datereported},{date.resolved}) <= 2 then 1

Then create formulas like the following for each:
sum({@<=2 Days},{table.group}) % distinctcount({table.issueno},{table.group})

Place the summary formulas in the group header or footer and suppress the details.

-LB

 

[OKCMikeSoll]

Thanks LB,

It looks like everything is working except the one for the < 1 Day. The percentage is not correct when I try to validate the numbers. It is right on the dot for the 2 Days and 3 Days feilds. Any thoughts?

Thanks,
Mike Soll

 

[OKCMikeSoll]

Nevermind just a little "user error". Everything is working great.. Once again LB saves the day!

Thanks,
Mike Soll