| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Sum of Calculated fields in Pivot Table
I have a pivot table that summarises invoice values that are in different
currencies. I added a calculated field to calculate the GBP value of each invoice, but the pivot table seems to base the calculation on the sum values rather that calculating first then summing the calculated field. Eg Customer Invoice value Exchane Rate 1 1500 1.5 1 2000 1.6 Instead of getting 2250 (1500/1.5) + (2000/1.6) I get 1129 (3500/3.1). Can I force it to calculate the invoice value first? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Calculated Field in Pivot Table | Excel Worksheet Functions | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
| pivot table question, sum fields? | Excel Worksheet Functions | |||
| Is there an autofill for all row fields in a pivot table? | Excel Worksheet Functions | |||
Hybrid Mode
