Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Does someone have any suggestions or better ways how to use input box variables and display them in a table or pivot table so they matches selected dimensions inside the table?
I have a table like this:
Region Month Actual
North 1 20
North 2 25
North 3 30
South 1 10
South 2 15
South 3 10
Want to do something like this:
Target (Input box)
North_1 Variable(ex.10)
North_2 Variable(ex.15)
North_3 Variable(ex.20)
South _1 Variable(ex.5)
South _2 Variable(ex.10)
South _3 Variable(ex.15)
Region Month Target Actual
North 1 10 20
North 2 15 25
North 3 20 30
South 1 5 10
South 2 10 15
South 3 15 10
Thanks
-Johan
You can probably define an input field in the script instead of using N variables.
INPUTFIELD Target;
Table1:
load Region, Month, 0 as Target, Actual
from ...somewhere...;
You can then simply update the values in the Target field in charts by clicking on the value in the field and entering another value.
Thanks for the advice Gysbert. That’s a really interesting and helpful function.