If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Grouping a Calculated Column

Started by kbasha2004, 29 May 2008 01:58:16 PM

Previous topic - Next topic

kbasha2004

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

Gopinath

Set the Level Span property of % of Quantity to Product Line.

wyconian

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