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 ?
Quote from: CognosBIUser1 on 14 Jan 2019 05:10:13 PM
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.