Different format for Calculated Item in pivot table

[Christine]

I am using a Calculated Item to show the change between 2008 and 2007 sales,
and would like to have that shown as a percentage, but the format for Sum of
Sales is a number. Is there a way to specify the percentage format in the
formula such as =percent(('2008'-'2007')/'2007')?
Thank you in advance for your replies.
Chris

 

[Luke M]

Move your cursor toward the outer edge of the field heading. It shoudl change
to an arrow, similar to what you'd see if you were selecting a row. Click.
Now, Ctrl+1 to format cells, choose percentage.

 

[Christine]

Thank you very much.

Move your cursor toward the outer edge of the field heading. It shoudl change
to an arrow, similar to what you'd see if you were selecting a row. Click.
Now, Ctrl+1 to format cells, choose percentage.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*