2 Replies Latest reply: May 3, 2016 10:24 PM by Sunny Talwar RSS

    Waterfall chart with relative values

    Carolina Nötzli

      Dear all

       

      I need to change the expressions in my waterfall chart into relative expressions . It does not work by simply selecting checkbox "Relative".

      I would like to show

      Sales =100%

      Sales dedcutions=10%

      Material cost=20%

      ...

       

      Thanks a lot for your help

        • Re: Waterfall chart with relative values
          Stefan Wühl

          If your sales expression is currently something like

           

          =Sum(Sales)

           

          then try to divide all your expressions by Sum(Sales)

           

          Sales:

          =Sum(Sales) / Sum(Sales) // or simply 1

           

          Sales deductions:

          =Sum([Sales deductions]) / Sum(Sales)

           

          Material Cost:

          =Sum(Cost) / Sum(Sales)

           

          and format the numbers using num() function or on number tab as percentages.

          • Re: Waterfall chart with relative values
            Sunny Talwar

            Are you using multiple expressions or just one expression with if statement?

             

            May be you need to do something like this if you have a dimension called Dim for instance

             

            Dim                              Value

            Sales                            140

            Sales deductions          14

            Cost                              28

            .

            .

             

            Sum(Value)/Sum(TOTAL {<Dim = {'Sales'}>} Value)