1 Reply Latest reply: Dec 6, 2012 1:16 AM by Maqs-Oracle RSS

    Can I move a Calculated column to  a specified row?

    anne415
      Hi all,

      The version is 11.1.1.6.5.

      Can I move a Calculated column to a specified row?

      Such as:

      Region-----------------Sales
      Shanghai--------------100
      Beijing------------------200
      Shanghai+Beijing----300
      Guangzhou-----------100
      Total-------------------400

      Regards,
      Anne
        • 1. Re: Can I move a Calculated column to  a specified row?
          Maqs-Oracle
          Create a Union report with columns as

          1 Region Sales

          Filter where Region in (Shanghai, Beijing)

          UNION

          2 'Shanghai+Beijing' Sales

          Filter where Region in (Shanghai, Beijing)

          Union

          3 Region Sales

          Filter where Region not in (Shanghai, Beijing)

          Union

          4 'Total' Sales


          note the first column is hardcoded numbers in formula like 1 , 2 , 3 and 4. Order by this column ascending.

          Now use conditional formatting to make 'Shanghai+Beijing' and Total Bold.


          Thanks