COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: JoelR on 27 Dec 2007 11:23:11 AM

Title: percent of the overall total
Post by: JoelR on 27 Dec 2007 11:23:11 AM
I have one status Column that changes to three columns in my crosstab after aggregation because there are many statuses.  I want to get the percent of the overall total on all of the statuses.  How do I do this?
Title: Re: percent of the overall total
Post by: MFGF on 07 Jan 2008 03:03:30 PM
Hi,

Sorry - I'm not quite following your description of the problem.  What do you mean when you say:

Quoteone status Column that changes to three columns in my crosstab after aggregation because there are many statuses

Do you mean that the column is so long it spans 3 pages, or are you saying you get 3 separate columns listed next to each other in the crosstab?

MF.