View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Different format for Calculated Item in pivot table

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!*


"Christine" wrote:

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