Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Totals in Crosstabs

Status
Not open for further replies.

Danielbryanuk

Technical User
Sep 26, 2007
48
DE
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



 
I have the exact same issue, have you found a solution? Have anyone else overcome this issue?
 
Still not heard anything or solved the problem - can anyone help?? Please???
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top