Pivot Tables
 

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

Pivot Tables
 

Hi Ann,

Enclose the first part of the calculation in brackets: =(C5-C4)/C4 and
format the cell as a percentage: Format = Cells = Percentage.

Division and multiplication will always be carried out before subtraction
and addition, so you were actually calculating C5 - 1.

Ewan.

"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

Pivot Tables
 

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

Pivot Tables
 

Hi,

If you are trying to add a calculated field to the pivot table I'd add one
that is the same as your 'sales'. Then in your field settings pick 'Options',
change show data as % Difference From, change base field to your time period
(month) & select 'previous' as your base item ... and hopefully you get
something like you need.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"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

Pivot Tables
 

Thanks but I was just giving an example of the formula I know how to create
it - I was wondering if it is possible to do this as part of my pivot table.
Right click on pivot table - go to formula - can't get it to include.

Thanks
--
Kind regards

Ann Shaw


"ewan7279" wrote:

Hi Ann,

Enclose the first part of the calculation in brackets: =(C5-C4)/C4 and
format the cell as a percentage: Format = Cells = Percentage.

Division and multiplication will always be carried out before subtraction
and addition, so you were actually calculating C5 - 1.

Ewan.

"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