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

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

Different format for Calculated Item in pivot table
 

Thank you very much.

"Luke M" wrote:

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