Crosstab row totals

[EArumugam]

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

[PRIT AMRIT]

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

[PRIT AMRIT]

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

[EArumugam]

sorry prit.

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

PFA

active and open are different measures.

thanks,
eas

[PRIT AMRIT]

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