SUM is not showing correctly while drilldown in olap cube source report

[sivabisnai]

Hai,

I have a question in Report Studio(cognos8),iam using the cube to develop a report ,
My question is
i have a cross tab report with rows as regions and cols as Cases and mesaure as Qty when ever i run the report it shows the report as

qty     HR          MK       casestotal

AP    9.29%   2.42%      11.72%
MH
GOA

when ever i drilldown the HR i got another hirarchy with  values as shown

qty  H1     H2    H3   H4      H5    H6        H7       H8   H9                 HR             
AP   7.34% 0.08% 0.07% 0.05% 1.22% 0.52% 2.84% 0.14% 0.16%   12.41%

Now the Problem is   from the above HR shown as 9.29%
From the below its showing that 12.41%

Could u please give any suggestion on that issue
Thanks in advancre

[rockytopmark]

Change SUM to Aggregate

[rockytopmark]

Also, you posted your Q in the wrong forum... you will do better for yourself by postiing in the correct forum, which would be Cognos 8 --> Report Studio

[sivabisnai]

i alredy try with that  but i didn't get correct sum
as same as 9.29

[sivabisnai]

Iam new to this form