4 Replies Latest reply: Jan 19, 2012 9:51 AM by Amey Pantoji RSS

    How to pull data from crosstable

      Hi everyone,

      I am facing a problem while pulling data from a crosstable. Below table displays maintenance cost for different products per year for Q1 to Q4. This table is present in excel sheet.

       

      2010 2011
      ProductQ1Q2Q3Q4Q1Q2Q3Q4
      Cycle10006500456058602000450012302450
      Bike20004500123024501000650045605860
      Car30005000321065802000300050003210
      Truck400050045601245300040005004560

       

      I want this data to be pulled in a QVW and dispalyed in below manner.  How to pull data from above kind of tables in a organised way?

      Product YearQuarterMaintenance Cost
      Cycle2007Q11000
      Cycle2007Q26500
      Cycle2007Q34560
      Cycle2007Q45860
      Bike2007Q12000
      Bike2007Q24500
      Bike2007Q31230
      Bike2007Q42450


      Thanks,

      Amey.