9 Replies Latest reply: Nov 9, 2016 2:26 AM by Tresesco B RSS

    how to pick a value

    naveen kumar

      Hi All,i need help in one of my requirement,for example i got like below

       

       

      Place       customer                       value

      LP               fox                             1000

      LP               fox                             2000

      LP               fox                             3000

      LP               happy                         8000

      LP               happy                         6000

      LP               happy                         7000

      DS               fox                             10000

      DS               fox                             90000

      DS               fox                             30000

      DS               happy                         10008

      DS               happy                         1032

      DS            happy                         1067


      so now i need to write a expression in a way that,if i select

      LP value from Place field and fox as customer then it should pick one value from the above three values (1000,2000,3000)

      LP value from Place field and happy as customer then it should pick one value from the above three values (8000,6000,7000)

      i mean the expression should be dynamic .....

      Note :This is just a sample values ,In client data i got more value (more then 3)for each customer .......

       



      thanks

      naveen