3 Replies Latest reply on Jul 11, 2012 6:32 PM by SriniVEERAVALLI

    OBIEE: How to alter data format of a new calculated column in pivot table.

    937650
      Hi,
      I create a pivot table in OBIEE 11g that have a Measure. Base on the Measure I create a new calculated
      item and the custom formula is ($-1-$-2)/$1*100. But the new column and the Measure column need
      different data format-the Measure column is number type,the new column need percentage type.
      How can I alter data format of a new calculated column in pivot table?
      Another quest, If OBIEE pivot table have two measure in a dimension,
      How can I realize a new calculated item that base one measure use the custom formula ($-1-$-2) and
      base another measure use the custom formula ($-1-$-2)/$1*100?

      regards,
      samantha