Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning from Germany,
I have a question abou how to toggle the view in a chart from absolute values to procentage?
Example: the two (2) waterfall graphs showing the Revenue to margin development one in absolute fiagures the other as procentage.
How to have one graph and switch in the grapgh from one view to the other?
Thanks for your help, Matthias
You can use bar offset
Hi,
You can create a button to switch between two views.
create a variable say vSwitch and assign a value 0 to it.
now create a button and set action as set variable.. not(vSwitch)
now in your chart expression if($(vSwitch)=0, sum(values),count(values))
HTH
sushil
Like this
Regards
ASHFAQ
Hi,
Create two expressions
Exp1: Actual
Sum(Sales)
Exp2: %
Sum(Sales)/Sum(TOTAL Sales)
Now Click on second expression, and click on the Group button in
Chart Properties -> Expression tab
Now the icon is created on the chart by click that icon you can toggle the expressions.
Hope this helps you.
Regards,
Jagan.
Hi,
Check if this helps
regards
ASHFAQ
Thanks Amit, this dose the trick. Have fun, Matthias
Cheers
Thanks,
AS