Possible values selection

[sachinryeola]

  HI Guys,

Below is the sample table.

Query:

there will be two tables  Entry No an FS Line.

I want the possible values straight table for FS line.

Ex.

If I select A from FS LIne there will be associated values selection in Entry No list box,

Now i want to create a straight table where a column will show other FS lines which are related to those entry nos in ENtry No listbox.

Entry NO	FS Line
1	A
2	B
3	C
4	A
5	B
1	C
2	A
3	B
4	C
5	A

IF i select A in FS Line i will get 1,2,4,5 in Entry No

Now i want to create straight table where i will get FS lines related to 1,2,4,5

Plz suggest ASAP

Regards,

Sachin

[Anonymous]

Hello!

Can you see my attachment?

I used alternate states with Field Event Trigger (OnSelect) for FS Line

Let me know if it can be usefull.

Elena

[rwunderlich]

You can do this with the set expression

  {<[Entry NO]=p(), [FS Line]=>}

You can either put the set in the chart expression(s) like:

  =sum( {<[Entry NO]=p(), [FS Line]=>} Value)

or perhaps easier, create your [FS Line] chart dim as a calculated dimension like this:

  =aggr(only({<[Entry NO]=p(), [FS Line]=>}[FS Line]),[FS Line])

-Rob

http://masterssummit.com

http://robwunderlich.com