3 Replies Latest reply: Aug 19, 2014 10:54 AM by Sankar ganesh RSS

    Cross table

    Sankar ganesh

      Table 1:

      ProductMericValueTarget
      AAAMetric110
      AAAMetric220
      AAAMetric330
      BBBMetric1100
      BBBMetric2200
      BBBMetric3300

       

       

      Table_2:

       

      ProductMetric1Metric2Metric3
      AAA102030
      BBB100200300

       

      Hi,

       

      I want to convert the table-1 in the table-2 format as specified above. Can anyone give your ideas ?

       

       

      Thanks,

      Sankar