CrossTab Totalling

[darners69]

I have an issue with Nested cross tab totalling


I have attached a screen shot with what I want to see and what I actually see

These are the steps I have taken

Created a Total on Customer
Added Transaction Type under Total
Added Query Calculations for Qty and Value nested under Transaction Type
Set the above Aggregation to Calculated

Hope I have explained it well enough :)

Cheers

[bus_pass_man]

It's double counting -- literally -- so that's the first thing to try to investigate.

[sdf]

what is your query for the totals?