How to aggregate only positive values from detail in summary row?

[cognosbiuser]

Hi Folks,

I have an urgent requirement hope you guys can help me.

I am using DMR model,Cross tab with three measures.Please find the attached document I have clearly mentioned my requirement in that document.

My requirement is i want  to aggregate  only positive values for a particular children(EG:Children a).I should not do it directly on measure because that will effect to entire crosstab. So is there any way to do this requirement without effecting to entire cross tab.

I have tried using if else,value conversion,children identifying way nothing worked.

Can we use something like where my measure<0 for particular member or aggregate only positive values.

PFA for more clarification it will give you very clear picture.If possible please help me ASAP.

Regards
BI User

[BOC]

Hi BiUser

if(filter(levelofchildren=USA)within set MTD>0) then (MTD*0)
OR filter(levelofchildren=UK)within set MTD>0) then (MTD*0)
----
---
)
Regards
boc