Print Page - [SOLVD]Re: subtotal of a cross tab with average, total and count 4 seperate clmn

Title: [SOLVD]Re: subtotal of a cross tab with average, total and count 4 seperate clmn
Post by: UseCog on 31 Mar 2009 03:48:35 AM

Hi All,

I have a cross tab and I want to show the subtotal of the cross tab. But I want to show total for the first column, average for the second column and count for the 3rd column

any helps on this please

Title: [SOLVD]Re: subtotal of a cross tab with average, total and count 4 seperate clmn
Post by: UseCog on 31 Mar 2009 06:24:54 AM

Thanks for your thoughts. I have got the solution

Rather than using a specific type of aggregation (such as Total or Average), click on the Summary button and select Aggregate. This will use the Rollup Aggregate Function defined for each data item in the query. If the rollup aggregate function is Automatic, the aggregate function defined for the data item in the model will be used instead

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: UseCog on 31 Mar 2009 03:48:35 AM