display variable outcome in each row.

[everest226]

Name                             Total goal                                                                      Avg Goal

Ronaldo              10( variable returns that value)                                                  40 ( variable returns that value)   

Messi                  5( variable returns that value)                                               41( variable returns that value)

etc,,,,

all goal and avg goal is calculate by variable in each row ....what kind of object that i have to use to get this value to display and how

thanks,,

[trdandamudi]

Can you please share some sample data along with expected output....

[everest226]

its just a concept that i am working on.is it possible.

[sunny_talwar]

I guess we are not sure what you envision, can you try to put your vision down on Excel?

[everest226]

the requirement is that i have a 10 student names in one column and other two column are there averages of  total book read and other is total class average which is also set by variable  . i am trying to create object which is readable only .

[SunilChauhan]

Create two variable with set expression. provide Calculation logic in it

and in table expression right using $ sign for both variable

[ankit777]

Hi

Its possible.

Create both variable and write your expression without preceding '='

Now use this variable in your chart expression as =$(Variable)

To display data like shown above use a Straight table.

This should work.

[Kushal_Chawda · Accepted solution]

You need to use Synthetic dimension

create straight table

Dimension:

=valuelist('Ronaldo','Messi')

Expression:

1) Total Goal

= Pick( match(valuelist('Ronaldo','Messi'),'Ronaldo','Messi'),

$(VariableForRonaldo),$(VariableForMessi))

1) Avg Goal

= Pick( match(valuelist('Ronaldo','Messi'),'Ronaldo','Messi'),

$(VariableForRonaldo),$(VariableForMessi))

[tresesco]

Is your emphasis on

Ujjwal kc wrote:

.....object which is readable only .

?

If so, you could create a straight table and make it read-only by checking 'Read Only' in general tab of the chart.

[everest226]

Thanks Kushal

could you please elaborate on the expression for total goal and average goals???

Expression:

1) Total Goal

= Pick( match(valuelist('Ronaldo','Messi'),'Ronaldo','Messi'),

$(VariableForRonaldo),$(VariableForMessi))

1) Avg Goal

= Pick( match(valuelist('Ronaldo','Messi'),'Ronaldo','Messi'),

$(VariableForRonaldo),$(VariableForMessi))

I dont get the variable part???