Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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