Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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)