2 Replies Latest reply: Jun 11, 2013 6:33 AM by user1954935 RSS

    How to change the data format for a Duplicate Layer in a OBI Pivot Report ?

    user1954935

      Hi,

      I have created OBI pivot report which displays the BU wise Amounts for each company. The data format for Amount is Number with 2 decimal places.

      I wanted to also display the percentage of the BU wise amount next to Amount column.

      So, created a duplicate layer from the Amount column and then changed the property "Show data As" -> "Percent of" -> "Section".

      This works fine except the data format is One decimal places.

      How to format this % value to Two decimal places same as the Amount ?