Hello,
I am new to Cognos so please bear with me
I need help creating a percentage of total calculation in a crosstab report.
The data I am reporting on is performance rating (row) , performance potential (columns) and number of people with certain perf. rating and perf. potential (the measures). So I want to add a second row as a measure calculating the following:
(number of employees with certain perf. rating and perf. potential)/(total employees in report)
I currently get the total as a second query.
Any ideas how I can accomplish this will be greatly appreciated.
Thanks,
AB
I am new to Cognos so please bear with me
I need help creating a percentage of total calculation in a crosstab report.
The data I am reporting on is performance rating (row) , performance potential (columns) and number of people with certain perf. rating and perf. potential (the measures). So I want to add a second row as a measure calculating the following:
(number of employees with certain perf. rating and perf. potential)/(total employees in report)
I currently get the total as a second query.
Any ideas how I can accomplish this will be greatly appreciated.
Thanks,
AB