4 Replies Latest reply on Jul 19, 2013 10:11 AM by Jonathan Drummey

    Columns data to rows drilltrough

    sam com

      Hi,

      I need to create a report displaying T2 data, and my requirement is clicking/hovering (hovering is preferable) on Col1 data should display all the associated description from Table T1.

      Constraints:

      Our project is not accepting restructure of data from T2 Col1 to Rows on the database.

      There is no limit on number of key matches (A1,A2,A3, ..........)

       

      Sample data below:

      Table T1
      KeyDescription
      A1Desc1
      A2Desc2
      A3Desc3
      B1Desc4
      C1Desc5
      Table T2
      KeyCol1
      q1A1,A2
      q2A1,B1,A3
      q3B1

       

      Attached one sample work sheet.

       

      Message was edited by: sam com Sorry ... attached .twbx file .