Crosstab report total on a DMR Source

[CognosBIUser1]

Hi,

I want to display the total at the bottom of the report. but it seem to change (incorrectly )as I do expand on the levels in my hierarchy and I only want it to only reflect the correct amount.
Not could the amount from the expended members. How do I do this in dimensional reporting ?

[MFGF]

Hi,

I want to display the total at the bottom of the report. but it seem to change (incorrectly )as I do expand on the levels in my hierarchy and I only want it to only reflect the correct amount.
Not could the amount from the expended members. How do I do this in dimensional reporting ?

How is your total defined currently? Is it an automatic summary? You could try adding a query calculation using the approach aggregate(currentMeasure within set [your set of row members])

Cheers!

MF.