| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table and Calculated Field
Could really use some help here.
I have a Pivot Table to which I've added a Calculated Field of another column squared. The problem is that in the totals I'd like to see the sum of the individual squared results rather than the square of the total. 10 100 10 100 20 400 For example, in the data set above I'd like the final cell to read 200 (100+100) rather than 400 (20^2). Is there a way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display the source for a pivot table page field | Excel Worksheet Functions | |||
| Calculated field in pivot table | Excel Discussion (Misc queries) | |||
| Totals of calculated field in pivot table give incorrect results | Excel Worksheet Functions | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Threaded Mode
