COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: darners69 on 13 Jul 2018 02:16:38 AM

Title: CrossTab Totalling
Post by: darners69 on 13 Jul 2018 02:16:38 AM
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



Title: Re: CrossTab Totalling
Post by: bus_pass_man on 13 Jul 2018 06:19:41 AM
It's double counting -- literally -- so that's the first thing to try to investigate.




Title: Re: CrossTab Totalling
Post by: sdf on 17 Jul 2018 01:10:55 PM
what is your query for the totals?