| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculated Fields in Pivot Table
In Excel 2007 Is it possible to create a calculated field using the sum of an
numeric field divided by the sum of a text? My table has a list of products (text) which I have counted and the sum of the associated revenue (numeric). Currently I calculate an the average outside the table. However, when a new product is introduced the grand total formula is eliminated. When I added a calculated field the results are #DIV/0!. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Calculated Fields | Charts and Charting in Excel | |||
| pivot table calculated fields | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated Fields | Excel Discussion (Misc queries) | |||
| Pivot Table with Calculated Fields | Excel Discussion (Misc queries) | |||
| Sum of Calculated fields in Pivot Table | Excel Discussion (Misc queries) | |||
Threaded Mode
