Totals in Crosstabs

[Danielbryanuk]

Hello again all...another issue I know!

I have a cross tab that contains 5 measures (all calculated), grouped by one member in the column and 4 members in the rows. For each row member there nested total line, which performs a sum of the crosstab fact cells.

The trouble is that for one measure I need to row total to be a calculation, rather than just summing the fact cells.

To do this I have tried deleting the contents of the crosstab intersection for this measure and all row memebers, setting "Define Contents" property to Yes, then adding a query calculation, and setting the aggregate function to "Calculated".

When running the report these intersections are left blank, with everything else correct.

Is this the correct method to be using?

I am on version 8.3 Report studio.

Thanks
Dan

 

[amonterou]

I have the exact same issue, have you found a solution? Have anyone else overcome this issue?

 

[Danielbryanuk]

Still not heard anything or solved the problem - can anyone help?? Please???