Adding a New Column

[#1]

Hi Everyone,

I have 3 columns A, B and C in my table, Now I need to create another column D, where D=(A+B+C)* n where n can range from 1 to 10.

I want to show all these four columns on my dashboard and just by selecting value of n in slider I will have the required table on dashboard.

If there is any video available on you tube, kindly provide the link.

Thanks in Advance !!

Regards

Anjana

[Anonymous]

Hi Anjana,

In Script reload your table with all A,B,C columns.

Now create a variable as vInput and provide min and max values as 1 and 10 respectively.

Create a slider and assign vInput to it.

Now create a straight table with A,B,C as Dimension and a expression as:

(sum(A+B+c))*vInput.

Now when you wil slide you vInput values, the chart will reflect accordingly..

Hope this helps you.

regards

Nitin

[bbi_mba_76]

Hi,

you have to create a chart, select straight table in the general tab, add the 3 dimensions, A,B,C and then in the expression tab =(A+B+C)*n

Create the variable n (Settings > variable overview) and then the slider object, in which you select the variable n.

[sujeetsingh · Accepted solution]

Anjana , please have a look on this sample .

[#5]

Hi,

I am able to create this variable n  but When I create this straight table, there are only columns heading but no values under Heading A,B C and D.

Kindly help !!

Anjana

[sujeetsingh]

Miss!

have a look on the sample  i have just given in my comment .

To create a variable just go to Settings>>DocumentProperties>>Variables Tab>>

And then add new variable and name .

Now call it in the slider object

[#7]

Hi Everyone,

Thanks for the help.

I am Know able to create the required table.

Wish you all a happy New Year

Thanks once again !!!

Anjana

[sujeetsingh]

A very Happy New Year to you MISS!!

Are not able to see the comment of mine with a sample attached .

Hope you get some help from it.