Selected value in listbox should only display in table

[hemachandran]

Hi,

  I have four listbox of same field

Eg. Product field as product1

      Product field as product2

      Product field as product3

      Product field as product4

I have four list box

In that product1 listbox  i select tv

           product2 listbox  i select table

           product3 listbox not selected

           product4 listbox not selected 

My requirement is... In straight table i want to display the only selected product ie,

Product          Amount

TV                   10000

Table                 500

I have attached the sample file..

thanks in Advance....              

[varshavig12]

Hope this helps!

[varshavig12]

You can also try something with calculated dimension.

[Anonymous]

Hi,

You can try this in Expressions tab :

=sum(if(GetSelectedCount(Product)>'0',Amount,0))