PivotTable: Difference from Row Items
 

I have five data items in a pivot table for which two are
1. Average of AdjustedPrice
2. Average of MarketPrice

Is it possible to create a formula that would show the difference of
these two summaries within the PivotTable?

(Field Settings | Options | Differnce From will not work for rows)
:mad:

TIA
astrodon


--
astrodon

Born, School, Job - just like everyone else
------------------------------------------------------------------------
astrodon's Profile: http://www.excelforum.com/member.php...o&userid=18475
View this thread: http://www.excelforum.com/showthread...hreadid=515274

PivotTable: Difference from Row Items
 

I'm not sure why a custom calculation wouldn't work.

You may want to look at how Debra Dalgleish explains it:
http://contextures.com/xlPivot10.html

astrodon wrote:

I have five data items in a pivot table for which two are
1. Average of AdjustedPrice
2. Average of MarketPrice

Is it possible to create a formula that would show the difference of
these two summaries within the PivotTable?

(Field Settings | Options | Differnce From will not work for rows)
:mad:

TIA
astrodon

--
astrodon

Born, School, Job - just like everyone else
------------------------------------------------------------------------
astrodon's Profile: http://www.excelforum.com/member.php...o&userid=18475
View this thread: http://www.excelforum.com/showthread...hreadid=515274

--

Dave Peterson