Print Page - Crosstab Space - with singleton -need help??--Multiple Subtotal

Title: Crosstab Space - with singleton -need help??--Multiple Subtotal
Post by: markcognos on 21 Feb 2012 10:03:29 PM

Hi All,

See Attached File..

Need Help to get have a crosstab space to compute % Share in Another Crosstab Space..I used Crosstab space without facts then insert a singleton into cell,then i Set the singleton to a query that contains the calculation..I insert my calculation data item 1 which is

Total(abs([SQL1].[delivered_cases]))/total(abs([SQL1].[delivered_cases]) for [SQL1].[REGION2])

then i run the report and there is an error..

Measure valueSet="delivered_cases" can not have another measure as an attribute: groupBody="%SHARE".

See Attached File..

Thanks,

Title: Re: Crosstab Space - with singleton -need help??--Multiple Subtotal
Post by: blom0344 on 23 Feb 2012 03:57:46 AM

As your post is still on page 1 of the C8 Report Studio forum I deleted some of the 'Ups'

By the way, does you singleton work elsewhere within the report?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: markcognos on 21 Feb 2012 10:03:29 PM