Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data format in pivot table calculated item

gillespAug 24 2009 — edited Feb 14 2013

Hi All,

I've got a pivot table with a dimension on rows and a dimension on columns and a measure. I have a "new calculated item" based on the dimension on the columns which does the following: ( ($2-$1) / ($1) ) *100

I want this calculated item shown as a percentage like 1,2% but the measure must stay a whole number like 1234 (no decimal places or percentage symbols) any suggestions on how to achieve this?

Thanks in advance!
Gilles

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 14 2013

Added on Aug 24 2009

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

12 comments

2,649 views