Multiple measures in crosstab - Cognos 8

percentage crosstab cognos
Nabegh picture Nabegh · Jun 10, 2012 · Viewed 7.4k times · Source

Is it possible to add more than one measure in a single crosstab?

I have a crosstab in which rows represent departments and columns represent gender. It is possible to display counts and percentages?

I am reporting from relational data.

Answer

Deepa picture Deepa · Jul 18, 2012

Yes. You can add multiple measures to your crosstab by nesting them in either rows or columns.
In your example, nest Counts and Percentages under Departments row or Gender Column.

Given below is an example of displaying two measures Revenue and Quantity in a crosstab. enter image description here

The result looks like this: enter image description here

Please refer to IBM Infocenter for more details on nested Crosstab. http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp

Related questions

How do I calculate the percentage of a number?

I would like to calculate, in PHP, the percentage of a number. For example: $percentage = 50; $totalWidth = 350; For this example, 50% of 350 = 175 How can I do that?

Read More
Format number as percent in MS SQL Server

I am trying to simply format a number as a percent with two decimal places. If it is 37 divided by 38 (aka .973684210526315789), I would like it to show 97.36 % in the SQL output. I know it is recommended to do formatting in …

Read More
How do I print the percent sign(%) in c

I am a beginner in C, and I was wondering why this program does not print % sign? The code is: #include<stdio.h> main() { printf("%"); getch(); }

Read More