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

[markcognos]

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,

[blom0344]

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?