0 Replies Latest reply: Oct 16, 2018 1:48 AM by Mariam Ovasheli RSS

    Waterfall Chart

    Mariam Ovasheli

      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.

      Waterfall Chart.JPG

      (((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))))))