Counting displayed table rows

[Anonymous]

Hi,

I have 2 tables when I select from the fist one the second table is updated, can anyone please tell me how to count the rows in the second table? getselectedcount is not working because selection is done from the fist table.

Thank you.

[trdandamudi · Accepted solution]

Here is the complete script and the expression:

Tbl1:

Load * Inline [

ID

1

2

3

4

];

Tbl2:

Load * Inline [

ID,Type

1,A

1,A

2,B

3,C

3,C

3,C

4,D

4,D

4,D

4,D

4,D

];

Expression:

=If(GetSelectedCount(ID)=0,'',Count(Type))

Note: If nothing is selected then it will not show any count and that is the reason I am using IF condition.

Hope this helps...

[Anonymous]

Thanks a lot that was so helpful.

[trdandamudi]

You are welcome and happy to hear that it is helpful for you..