Storing Straight Table Column Name as Variable

[#1]

Hi Everyone,

I currently have a straight table with a series of mini-charts displaying data, however I was wondering if it were possible to store a column name as a variable on a mouse click even if it is an expression in the chart.  I am hoping to use the variable to display a dynamic chart across all my customers based on the selected metric.

Please let me know if you need clarification and thanks in advance for your help.

[its_anandrjs]

Hi,

Use Getfieldselections( ) command to fetch the field.

HTH

Regards

Anand

[#3]

Hi,

i hope this little example help u if this is that u are looking for

C u,

Stefano

[its_anandrjs]

Hi,

See the attached sample file you may be use some thing like this

Data:

LOAD * INLINE [

    ColA, ColB, ColC

    A, 145, 14

    B, 125, 23

    C, 242, 85

];

Rotate:

LOAD * INLINE

[

    Field

    ColB

    ColC

];

HTH

Regards

Anand

[its_anandrjs]

Hi,

Store selection value into variable like

vTest = Getfieldselections( Field )

and get this value in expression and calculate

= Sum( $ ( vTest ) )

and use a load with

Data:

LOAD * INLINE

[

    ColA, ColB, ColC

    A, 145, 14

    B, 125, 23

    C, 242, 85

];

Rotate:

LOAD * INLINE

[

    Field

    ColB

    ColC

];

See the attached

HTH

Regards

Anand

[its_anandrjs]

Hi,

You got correct answer with this solution.

Regards,

Anand

[#7]

Hi everyone,

Thank you for the replies.  I guess to more succinctly explain my problem:  I have a straight table and I would like a variable trigger (or its equivalent) on selecting an expression value (or it's header) within the table.  Is this possible?  I know it is possible with a field, but what about with an expression or header?

Thanks,

Uller

[#8]

If I understand u  can use "Group option" in the tab expression of the table.

So u can switch beetwen your expressions by clicking on the icon in the table...

Stefano.

[#9]

Hi,

Please see if the attached sample can help you.

Cheers.