Does anyone know of a way to add targets to a crosstab. I am using Crystal 2008. Currently the cross-tab looks like
Service1 Metric 1
Metric 2
Metric 3
Service2 Metric 1
Metric 2
Metric 3
Service3 Metric 1
Metric 2
Metric 3
What I would like to do is add a target column which is different for each service.
Service1 Metric 1 TargetService1Metric1
Metric 2 TargetService1Metric2
Metric 3 TargetService1Metric3
Service2 Metric 1 TargetService2Metric1
Metric 2 TargetService2Metric2
Metric 3 TargetService2Metric3
Service3 Metric 1 TargetService3Metric1
Metric 2 TargetService3Metric2
Metric 3 TargetService3Metric3
I can't hard code the values because they are different per service. I also want to avoid doing a mock crosstab because the data is spread across months and I would have to create suppression conditions for everything. Any ideas?
Service1 Metric 1
Metric 2
Metric 3
Service2 Metric 1
Metric 2
Metric 3
Service3 Metric 1
Metric 2
Metric 3
What I would like to do is add a target column which is different for each service.
Service1 Metric 1 TargetService1Metric1
Metric 2 TargetService1Metric2
Metric 3 TargetService1Metric3
Service2 Metric 1 TargetService2Metric1
Metric 2 TargetService2Metric2
Metric 3 TargetService2Metric3
Service3 Metric 1 TargetService3Metric1
Metric 2 TargetService3Metric2
Metric 3 TargetService3Metric3
I can't hard code the values because they are different per service. I also want to avoid doing a mock crosstab because the data is spread across months and I would have to create suppression conditions for everything. Any ideas?