2 Replies Latest reply: Oct 11, 2011 2:26 PM by mrkachhia RSS

    Showing Data Based on Selection

      I want to show sales data based on selection. Example enlcosed for your reference.

       

      Master Table is showing actual data I have in excel sheet.

       

      TABLE I WANT is the table I want based on selection from LIST BOX named PLEASE SELECT.

       

      Everything looks perfect... Now I want Product Name should be appeared as third column while I select ProductID.

      i.e. While I select ProductID in PLEASE SELECT LIST BOX... below table should appear.

       

      ProductIDProductNameTOTAL
      PRD 001FILES23000
      PRD 002MOBILE85000
      PRD 003NOTEBOOK11500
      TOTAL119500


      But if I select CustomeName or CustomerCountry, only two column should appear.

       

      Is it possible...

       

      Waiting for your kind reply...