This discussion is archived
1 Reply Latest reply: Dec 5, 2012 11:16 PM by Maqsood Hussain RSS

Can I move a Calculated column to  a specified row?

anne415 Newbie
Currently Being Moderated
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?
    Maqsood Hussain Journeyer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points