wshcraft70
asked on
Crystal Reports (Assistance with Calculated Members in a Crosstabs Report)
Here is my Crosstab...
The first column is HOURS (1 = pm) (so on...)
Next is a SUMMARY which is Distinctcount(BaseID)
Next is a SUMMARY which is Distinctcount(Date) *Total number days within period call for
Does anyone know how to use an embedded summary or a Calculated Member to add another summary to this crosstab report that will do the following:
If Hour = 1 then 709/21 distinctcount(BaseID)/dist inctcount( Date)
If Hour =2 then 725/21
I've got to find a way to calculate this average to report on a chart.
Total 5,281 21
1 709 21
2 725 21
3 698 21
4 689 21
5 267 21
8 70 18
9 311 20
10 500 20
11 637 21
12 675 21
The first column is HOURS (1 = pm) (so on...)
Next is a SUMMARY which is Distinctcount(BaseID)
Next is a SUMMARY which is Distinctcount(Date) *Total number days within period call for
Does anyone know how to use an embedded summary or a Calculated Member to add another summary to this crosstab report that will do the following:
If Hour = 1 then 709/21 distinctcount(BaseID)/dist
If Hour =2 then 725/21
I've got to find a way to calculate this average to report on a chart.
Total 5,281 21
1 709 21
2 725 21
3 698 21
4 689 21
5 267 21
8 70 18
9 311 20
10 500 20
11 637 21
12 675 21
ASKER
11
I don't think it is possible in CR XI. CR2008 added the capability to have calculated columns in a cross tab.
In CR XI I think you will have to build a manual cross tab.
mlmcc
In CR XI I think you will have to build a manual cross tab.
mlmcc
ASKER
manual cross tab?
You and James have helped me in the past with this darn report.. I continue to make progress but just can't get the averages.. :(
See attached report and .mdb access database..
Although currently my report is pulling from a SQL datasource..
Understood if it is simply not possible. But so discouraging.. Especially since the data is RIGHT there.. :D
callcenter.mdb
ACD-ICD-VIEW.rpt
You and James have helped me in the past with this darn report.. I continue to make progress but just can't get the averages.. :(
See attached report and .mdb access database..
Although currently my report is pulling from a SQL datasource..
Understood if it is simply not possible. But so discouraging.. Especially since the data is RIGHT there.. :D
callcenter.mdb
ACD-ICD-VIEW.rpt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
James.... You are simply a Saint to actually put this much time into this report in an effort to help me. I just can't begin to thank you enough. I wish I could give you 1 million points..
FWIW....... Which I also just learned the meaning of.. lol...
THANK YOU SOOOOOOOOOOOOOO MUCH for all your hard work..
CHEERS!!
FWIW....... Which I also just learned the meaning of.. lol...
THANK YOU SOOOOOOOOOOOOOO MUCH for all your hard work..
CHEERS!!
You're welcome. Glad I could help.
James
James
mlmcc