COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: kbasha2004 on 29 May 2008 01:58:16 PM

Title: Grouping a Calculated Column
Post by: kbasha2004 on 29 May 2008 01:58:16 PM
Hi All,

I've a percentage Calculated column which I need to group and show as one value For example: 50% in the center of the column.

Example :

Product Line, Product Name and % of Quantity all are gouped.
I get Product Line as grouped in center of the column, and a number of product Names. The % of Quantity is based on Product Line.
I need to see the % of Quantity for Peoduct Line as a single value.

Product Line   Product Name   % of Quantity
Campinging           Sports Shoes
Equipment   Tent                   50%
                Binoculars   
                Bed   
      
Please suggest how to do this in ReportNet

Thanks in advance!

KBasha
Title: Re: Grouping a Calculated Column
Post by: Gopinath on 30 May 2008 03:59:53 AM
Set the Level Span property of % of Quantity to Product Line.
Title: Re: Grouping a Calculated Column
Post by: wyconian on 30 May 2008 04:01:48 AM
Try using the group span option in the properties box for the list column body.  That should allow you to specify at which level your calculation appears