7 Replies Latest reply: Jan 10, 2013 2:58 AM by fiaz0419 RSS

    Pivot Col Heading

    970365
      Hi
      I have one report in 11g like below

      ---------------------------------Sal-----------     Am----
      ID------------Name---------------------------------          
      1-------------A---------------     1000--------4000
      2-------------B---------------     2000--------5000
      ---------------------------------------------------------


      First row header is measure values and second row header is Dimension row.
      My requirment is i should display in single row Like ID,NAME,SAL,AM

      I dont want to go table view.It should be pivot.