| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Formula not multiplying correctly
Excel 2007 - I have a pivot table with a formula in it that multiplies the
quantity and price of a product description. If there are no entries in my data that have the same product description and price the formula works just fine. However, if I have the same product description and same price it is adding up the prices first and then multiplying the sum of the quantities. It should only take the one price and then multiply the sum of the totals. Example below shows the answer should be 700, however the pivot table shows 1400 as the answer as it is adding (10+20)*(20*20). It should have (10+20)*20. It shouldn't sum the prices since they are the same. Description Qty Price Goobers (24ct) 10 20 Goobers (24ct) 25 20 Is there a way to fix this or turn a sum off? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get 2003 Excel pivot table to work correctly? | Excel Worksheet Functions | |||
| Pivot table: configuring calculated field correctly | Excel Discussion (Misc queries) | |||
| Total Not Summing Correctly on Calculated Fields in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table not sorting correctly | Charts and Charting in Excel | |||
| How to get pivot table Time field to appear correctly | Excel Worksheet Functions | |||
Threaded Mode
