CrossTab and conditionnal sum (Cognos 8, ReportNet) 1

[SPI33]

Hello all,
Is it possible to add sum of column or line in a cross tab. If yes, could you explain me how to do ?
Is it possible to filter the data included in this sum, for example:

Enterprise ProductType Sept Oct
Atelier1 toto 1 5
Atelier1 tata 2 6
Atelier2 toto 3 7
Atelier3 titi 4 8
Sum only for ProducType='toto' 4 12

Thank you for your help

 

[blom0344]

There is no client involved to store the query-set, so adding a filter will affect all objects that use the query.

A filtered set would require a second query.

You can use total or aggregate setting from the menu (aggregate symbol) on the body of the crosstab and Cognos will add totals for rows/columns..

Ties Blom