lauriesamh
Technical User
Hi, I'm using Cognos 8.3 Report Studio and a newbie to reporting in Cognos (prior experience with Crystal & Access). I'm working on a Crosstab that I only want to show percentages. I have developed multiple queries with the final one having the calculated percentages by month and Plan I need.
The query data contains the following:
Month/year
Plan
Count of Claim
Count Adjusted Claims
Count new Claims
Count New b. Claims
Reprocess Rate: (percentage calulated from above counts)
Auto Rate: (percentage calulated from above counts)
When I run the tablular data off the query I get accurate figures but I believe due to the aggregation in the crosstab the crosstab is resulting in 100 or 50 in each cell.
Sample desired
Plan A PlanB
1/2008 % %
2/2008 % %
Any help would be great!
The query data contains the following:
Month/year
Plan
Count of Claim
Count Adjusted Claims
Count new Claims
Count New b. Claims
Reprocess Rate: (percentage calulated from above counts)
Auto Rate: (percentage calulated from above counts)
When I run the tablular data off the query I get accurate figures but I believe due to the aggregation in the crosstab the crosstab is resulting in 100 or 50 in each cell.
Sample desired
Plan A PlanB
1/2008 % %
2/2008 % %
Any help would be great!