| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating from values in pivot tables
I want to perform a calculation on data in a pivot table which I then copy
down row by row but when I copy the formula down it does not work as it picks up the criteria in the first row of the pivot table. In old versions of Excel it just copied the simple formula down as opposed to putting in the pivot table criteria - how do I replicate this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables - Ranking Values | Excel Discussion (Misc queries) | |||
| Calculating in Pivot Tables | Excel Discussion (Misc queries) | |||
| Calculating fields in pivot tables | Excel Discussion (Misc queries) | |||
| Pivot tables with zero/null values | Excel Discussion (Misc queries) | |||
| Calculating percentages in pivot tables on subtotals | Excel Worksheet Functions | |||
Threaded Mode
