View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Christine Christine is offline
external usenet poster
 
Posts: 147
Default Different format for Calculated Item in pivot table

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