10 Replies Latest reply: Oct 11, 2011 8:39 AM by mrkachhia RSS

    showing profit based on selection

      I have below data...

       

      Customer NameCustomer CountryCustomer TotalSupplier NameSupplier CountryProductSupplier TotalProfit% Profit
      CUST001Germany100SUPP001FranceOIL901010.00%
      CUST003France300SUPP001FranceOIL2505016.67%
      CUST002Germany200SUPP002GermanySOAP1505025.00%
      CUST004USA400SUPP003ItalyEGGS380205.00%
      CUST005Australia100SUPP004SpainRADIO802020.00%
      CUST008France400SUPP004SpainRADIO30010025.00%
      CUST006Italy200SUPP005USATV1752512.50%
      CUST010Australia600SUPP005USATV5406010.00%
      CUST007Germany300SUPP006IndiaPHONE2703010.00%
      CUST009USA500SUPP006IndiaPHONE460408.00%


      I need to show a profit table based on different selection. But want to make only one table.

       

      My table should be displayed with below two columns.

      Selection & PROFIT%....

       

      where Selection could be any one from below which can be displayed as either list box, table box or multi box.

      Customer Name

      Customer Country

      Supplier Name

      Supplier Country

      Product

       

      Please help...

       

      Regards,

      Manish