Print Page - Crosstab row totals

Title: Crosstab row totals
Post by: EArumugam on 31 Jan 2011 01:26:58 AM

hi all,

how to achieve the crosstab row subtotals and grant total for the measure in row wise

please refer the attached screen shot.

i want to get the subtotal (marked in yellow) and the grand total (marked in green) in row wise.

thanks,
eas

Title: Re: Crosstab row totals
Post by: PRIT AMRIT on 31 Jan 2011 02:59:40 AM

Active & Open is a dimension value or 2 different measures?

Title: Re: Crosstab row totals
Post by: PRIT AMRIT on 31 Jan 2011 03:10:48 AM

Another thing, as per your attached screenshot SUB TOTAL & TOTAL figure would always be the same?

Title: Re: Crosstab row totals
Post by: EArumugam on 31 Jan 2011 03:40:14 AM

sorry prit.

little confused in attaching the screen shot. now its clear.

PFA

active and open are different measures.

thanks,
eas

Title: Re: Crosstab row totals
Post by: PRIT AMRIT on 31 Jan 2011 08:26:35 PM

Hi Eas,

You can't get the Sub Total or Total by using the 'Aggregate' option when u have more than one measures.

Find the attached XML and try to put the data items as shown and see if it works for u?

Thanks
P

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: EArumugam on 31 Jan 2011 01:26:58 AM