PivotTable: Difference from Row Items

  • Thread starter Thread starter astrodon
  • Start date Start date
A

astrodon

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 o
these two summaries within the PivotTable?

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

TIA
astrodo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference column in PivotTable 1
How do I get PivotTable data results to show in columns instead ro 4
PivotTable - Sum and Count 1
Drill Down in PivotTables 2
how to enable data option on a pivot table 2
Format Pivottables? 1
Dynamic PivotTable List 1
Dropdown list in PivotTable has deleted items. How to omit? 1

Back
Top