Waterfall Chart

[mariamovasheli]

Hello, in Waterfall chart I am Using  following set analysis it is working when nothing is selected but When I select dimension for only one part of this set it despairs. I need to write sum of this two because If I use Weighted average it is not correct. But How can I do this

so That when I filter Division = gas administration or gas retail to show only selected part? this is my chart and this expression is for

Volume variance. If you have any solutions or advice I would really appreciate.

(((sum({<AccountTypeName={'Revenue'}, VariablesName = {'Ebitda'}

,Division = {'Gas Retail'},

$(VCYM)>}Quantity))

-(sum({<AccountTypeName={'Revenue'}, VariablesName = {'Ebitda'}

,Division = {'Gas Retail'},

$(vPYM)>}Quantity)))

*

((SUm({<VariablesName ={'Ebitda'},AccountTypeName = {'Revenue'},Division = {'Gas Retail'},$(vPYM)>} Amount )

/

(sum({<AccountTypeName={'Revenue'}, VariablesName = {'Ebitda'}

,Division = {'Gas Retail'},

$(vPYM)>}Quantity))

)

-

(

SUm({<VariablesName ={'Expense'},Category ={'Cost of Gas'},Division = {'Gas Retail'} ,$(vPYM)>} Amount)

/

(sum({<AccountTypeName={'Revenue'}, VariablesName = {'Ebitda'}

,Division = {'Gas Retail'},

$(vPYM)>}Quantity)))))

+

((((sum({<AccountTypeName={'Revenue'}, VariablesName = {'Ebitda'}

,Division = {'Gas Administration'},

$(VCYM)>}Quantity))

-(sum({<AccountTypeName={'Revenue'}, VariablesName = {'Ebitda'}

,Division = {'Gas Administration'},

$(vPYM)>}Quantity)))

*

((SUm({<VariablesName ={'Ebitda'},AccountTypeName = {'Revenue'},Division = {'Gas Administration'},$(vPYM)>} Amount )

/

(sum({<AccountTypeName={'Revenue'}, VariablesName = {'Ebitda'}

,Division = {'Gas Administration'},

$(vPYM)>}Quantity))

)

-

(

SUm({<VariablesName ={'Expense'},Category ={'Cost of Gas'},Division = {'Gas Administration'} ,$(vPYM)>} Amount)

/

(sum({<AccountTypeName={'Revenue'}, VariablesName = {'Ebitda'}

,Division = {'Gas Administration'},

$(vPYM)>}Quantity))))))