0 Replies Latest reply: Apr 3, 2012 8:19 AM by mrkachhia RSS

    Column Data Based on List Box Selection


      Let me know if my enclosed example can be done by any other simple way.


      Check some description below to understand what I want to achieve.


      • I have multiple supplier i.e. SupplierA, SupplierB, SupplierC, SupplierD for different products i.e. FRUITs
      • My idea behind this example is to check % difference in prices of any supplier with respect to minimum price of all other supplier.
      • Upon selection supplier from Selection (LIST BOX PROPERTIES), respective prices from column 2,3,4 or 5 will be disappeared and column 8 will show price for the same supplier.
      • Column 9 will calculate % difference between price of selected supplier vs minimum price from all other supplier.