View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
astrodon
 
Posts: n/a
Default 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)


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