DIMENTION SET IN A CHART

[adiarnon]

i want to creat a chart that in the dimention it will get one of my fileds, lets say country, and i want to add one more value to the x axes of county that not excist in my table. for this new country i wiil calaulate the expression with an if statement in the expression.

how can i do that?

without changing the tables?

[lironbaram]

hi attach is an example

using dynamic update.

insert ab value to the input box , then press the button

the value will be added to the country field

in the chart the new value will get the average of all other countries.

[adiarnon]

tnx liron,

but if i want to add the value only for a specipic chart.

do i have any option to do that?

like in this chart,

i have a filed of year. in this chart only i want to add a bar of forecast (that not exist in the year filed)

and i calaulate the expression.

[lironbaram]

hi so you can

create a floating field let say yearForecast that will have all year values and forecast value added

then in the chart you can use if statements to calculate the results for example

sum(if(yearForecast=Year,Sales))

[adiarnon]

what do you mean by floating field?

i need to add the field to the sales table?

[lironbaram]

no you create an island table with one field

have a look at the attach model

[adiarnon]

tnx