How to Add a Calculation to a Pivot Table ?

Enter your formula in an adjacent column. It should automatically fill in
the pivot table functions you need.
At least that's what I've seen.
"Cheryl B." <CherylB@discussions.microsoft.com> wrote in message
news:CFD458CF-FD77-41E9-AC43-996C6AA15FBF@microsoft.com...
> This seems easy enough - and have figured out a quick & dirtly way - but
> need
> to get it into a formula.
>
> 'Created a pivot table and need to calculated the difference between two
> columns ... e.g. Monday has 11 widgets and Wednesday has 16 widgets ...
> what's the increase?

Hi, Barb -
Oh - I see. I need to type in the formula instead of mouse click cell J3
minus H3

Thanks for your response!


"Barb Reinhardt" wrote:

> Enter your formula in an adjacent column. It should automatically fill in
> the pivot table functions you need.
> At least that's what I've seen.
> "Cheryl B." <CherylB@discussions.microsoft.com> wrote in message
> news:CFD458CF-FD77-41E9-AC43-996C6AA15FBF@microsoft.com...
> > This seems easy enough - and have figured out a quick & dirtly way - but
> > need
> > to get it into a formula.
> >
> > 'Created a pivot table and need to calculated the difference between two
> > columns ... e.g. Monday has 11 widgets and Wednesday has 16 widgets ...
> > what's the increase?
>
>
>

You can use the 'Difference From' custom calculation. There's an example
here, using two years. You could use days instead:

http://www.contextures.com/xlPivot10.html#DiffFrom

And there are instructions here for turning off the Generate
GetPivotData feature:

http://www.contextures.com/xlPivot06.html

Cheryl B. wrote:
> This seems easy enough - and have figured out a quick & dirtly way - but need
> to get it into a formula.
>
> 'Created a pivot table and need to calculated the difference between two
> columns ... e.g. Monday has 11 widgets and Wednesday has 16 widgets ...
> what's the increase?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Enter your formula in an adjacent column. It should automatically fill in
the pivot table functions you need.
At least that's what I've seen.
"Cheryl B." <CherylB@discussions.microsoft.com> wrote in message
news:CFD458CF-FD77-41E9-AC43-996C6AA15FBF@microsoft.com...
> This seems easy enough - and have figured out a quick & dirtly way - but
> need
> to get it into a formula.
>
> 'Created a pivot table and need to calculated the difference between two
> columns ... e.g. Monday has 11 widgets and Wednesday has 16 widgets ...
> what's the increase?

Hi, Barb -
Oh - I see. I need to type in the formula instead of mouse click cell J3
minus H3

Thanks for your response!


"Barb Reinhardt" wrote:

> Enter your formula in an adjacent column. It should automatically fill in
> the pivot table functions you need.
> At least that's what I've seen.
> "Cheryl B." <CherylB@discussions.microsoft.com> wrote in message
> news:CFD458CF-FD77-41E9-AC43-996C6AA15FBF@microsoft.com...
> > This seems easy enough - and have figured out a quick & dirtly way - but
> > need
> > to get it into a formula.
> >
> > 'Created a pivot table and need to calculated the difference between two
> > columns ... e.g. Monday has 11 widgets and Wednesday has 16 widgets ...
> > what's the increase?
>
>
>

You can use the 'Difference From' custom calculation. There's an example
here, using two years. You could use days instead:

http://www.contextures.com/xlPivot10.html#DiffFrom

And there are instructions here for turning off the Generate
GetPivotData feature:

http://www.contextures.com/xlPivot06.html

Cheryl B. wrote:
> This seems easy enough - and have figured out a quick & dirtly way - but need
> to get it into a formula.
>
> 'Created a pivot table and need to calculated the difference between two
> columns ... e.g. Monday has 11 widgets and Wednesday has 16 widgets ...
> what's the increase?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

This seems easy enough - and have figured out a quick & dirtly way - but need
to get it into a formula.

'Created a pivot table and need to calculated the difference between two
columns ... e.g. Monday has 11 widgets and Wednesday has 16 widgets ...
what's the increase?

Enter your formula in an adjacent column. It should automatically fill in
the pivot table functions you need.
At least that's what I've seen.
"Cheryl B." <CherylB@discussions.microsoft.com> wrote in message
news:CFD458CF-FD77-41E9-AC43-996C6AA15FBF@microsoft.com...
> This seems easy enough - and have figured out a quick & dirtly way - but
> need
> to get it into a formula.
>
> 'Created a pivot table and need to calculated the difference between two
> columns ... e.g. Monday has 11 widgets and Wednesday has 16 widgets ...
> what's the increase?

Hi, Barb -
Oh - I see. I need to type in the formula instead of mouse click cell J3
minus H3

Thanks for your response!


"Barb Reinhardt" wrote:

> Enter your formula in an adjacent column. It should automatically fill in
> the pivot table functions you need.
> At least that's what I've seen.
> "Cheryl B." <CherylB@discussions.microsoft.com> wrote in message
> news:CFD458CF-FD77-41E9-AC43-996C6AA15FBF@microsoft.com...
> > This seems easy enough - and have figured out a quick & dirtly way - but
> > need
> > to get it into a formula.
> >
> > 'Created a pivot table and need to calculated the difference between two
> > columns ... e.g. Monday has 11 widgets and Wednesday has 16 widgets ...
> > what's the increase?
>
>
>

You can use the 'Difference From' custom calculation. There's an example
here, using two years. You could use days instead:

http://www.contextures.com/xlPivot10.html#DiffFrom

And there are instructions here for turning off the Generate
GetPivotData feature:

http://www.contextures.com/xlPivot06.html

Cheryl B. wrote:
> This seems easy enough - and have figured out a quick & dirtly way - but need
> to get it into a formula.
>
> 'Created a pivot table and need to calculated the difference between two
> columns ... e.g. Monday has 11 widgets and Wednesday has 16 widgets ...
> what's the increase?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html