Sum divide by sum Total

[ashmitp869]

Hi there ,

Please kindly suggest with the set analysis expression :

Expression :

%Death by /Death in whole 

Dimension : =[$(vDisplayedBy)]

Expression :

Sum({$<Mode_Desc={'Death'}>}Measure)/Sum({$<[Mode_Desc]={'Death'},[$(vDisplayedBy)]=>} Measure)

Sum(Measure)/Sum(Total <[$(vDisplayedBy)]>Measure) , I need to put the condition Mode_Desc={'Death'}

But my expression not working

Variable details:

set vDisplayedBy='Facility';

[abhijith28]

Can you attach the sample app.

[MayilVahanan]

Hi @ashmitp869 

Try like below

Sum({<Mode_Desc={'Death'}>}Measure)/Sum(Total <[$(vDisplayedBy)]> {<Mode_Desc={'Death'}>}Measure)