How to show total percentage in summary of crosstab

[HalfBloodPrince]

Hi Guys,

I am using cognos 11.0.13. I have cross tab report , I need to calculate  percentage and show the total in Summary lines of crosstab.
for example below is the expected output

Subject   Marks   Total   Percentage
maths   88   100   88%
Science   75   100   75%
English   65   100   65%
Total     228   300   76%

but i am getting the total of percentage in the Total
Subject   Marks   Total   Percentage
maths   88   100   88
Science   75   100   75
English   65   100   65
Total          228   300   228

is there any way to get the calculated percentage in summary ?

[MFGF]

Hi Guys,

I am using cognos 11.0.13. I have cross tab report , I need to calculate  percentage and show the total in Summary lines of crosstab.
for example below is the expected output

Subject   Marks   Total   Percentage
maths   88   100   88%
Science   75   100   75%
English   65   100   65%
Total     228   300   76%

but i am getting the total of percentage in the Total
Subject   Marks   Total   Percentage
maths   88   100   88
Science   75   100   75
English   65   100   65
Total          228   300   228

is there any way to get the calculated percentage in summary ?

Hi,

Is the percentage being calculated within the report or is it an item your report is reading and rendering? If you're calculating it in the report, setting the aggregation type to Calculated should give you the correct result. If not, you're going to have to calculate it yourself for the summary.

Cheers!

MF.

[BigChris]

Isn't there also something about the Solve Order for the percentage in the total row?

[HalfBloodPrince]

I am calculating the columns at report level. I have tried setting the solve order to 2 for percentage column and both summary and detail aggregation to calculated. but still its showing the same resulted. Anything I am missing or setting incorrectly .

Thanks in advance.

[MFGF]

I am calculating the columns at report level. I have tried setting the solve order to 2 for percentage column and both summary and detail aggregation to calculated. but still its showing the same resulted. Anything I am missing or setting incorrectly .

Thanks in advance.

Can you share the exact expression you are using?

MF.

[HalfBloodPrince]

simple percentage calculation (total([A])/Total() )*100. Row wise its calculating the percentages correctly. but in summary line its showing total of calculated percentages.

[MFGF]

simple percentage calculation (total([A])/Total() )*100. Row wise its calculating the percentages correctly. but in summary line its showing total of calculated percentages.

Hi,

Can you try changing the expression to

[Marks] / [Total]

Then use a percent format on the item in your crosstab?
Make sure the Summary Aggregation property for the item is set to Calculated
Then, in your crosstab, select the row edge, and use the Automatic summary option from the toolbar.

I just tried this with a simple report here and it works for me...

MF.

[HalfBloodPrince]

Thanks MFGF. It worked . thanks once again .