Different format for Calculated Item in pivot table

  • Thread starter Thread starter Christine
  • Start date Start date
C

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
 
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.
 
Thank you very much.

Luke M said:
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!*
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculated Item causes undue repitition in pivot table 2
Pivot table problem 4
Formula inside a Pivot Table 6
Pivot table 2
Pivot Table 2
How do I perform extended calculations in a Pivot Table in Excel 2 4
I want to create a calculated item based on a calculated field 1
Adding columns in pivot tables 4

Back
Top