title: Excel 2007 Pivot Tables Custom calculation?
body: <p>Again I'm wrestling with Excel 2007! I have some data I'm using to generate a Pivot Table and I'd like to divide all of the data by 1000... </p>
  
  <p>I know I could go in and change the original data by hand but I'd much rather have a formula in the Pivot table itself that does this for me.</p>
  
  <p>Any thoughts?</p>
  
  <p>ps: You guys are awesome!</p>