12 Replies Latest reply on Feb 14, 2013 11:31 AM by fledicu

    Data format in pivot table calculated item

      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!