Hi Annie,

This is how the formula should look:
=(C5-C4)/C4

Best regards,
Olle Svensson


"Annie" wrote:

Hi I am creating a Pivot Table from a large sheet brought in from Great
Plains. When I have the Pivot finished I want to use a formula to compare
two sales figures over two dates and maybe get the % difference.

Month 1/1/06 2/1/06

Sales 65200 65320

I am trying to incorporate a formula - = c5-c4/c4 but it's not working??
Any help would be greatly appreciated.


--
Kind regards

Ann Shaw