webi sections displaying incorrect subtotal

[Former Member]

Hi,

I initially applied a section on a Org code field and then I applied Sum on Amount which is resulting in a Grand total for each section instead of Sub total for each section.

FYI, Amount is the measure object with Aggregation SUM.

Please see the picture below, for the first section we should be getting sub-total of 1170 (600+570), etc.

I applied context functions, etc but for some reason I am unable to figure it out. Did anyone face this kind of issue before. If so, please help me figure it out.

FYI, I am using BO 4.1 SP 9.

Thanks & Regards.

Naveen.

[former_member198519]

Don't apply context in the sum. Just =Sum([Amount]) should be good enough.

[arijit_das]

Make sure the formula in the footer cell showing the sum is correct. Try changing it to : =Sum([Amount])