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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table and Calculated Field
Why not just add a formula (like =E24^2) next to the values and another to
do the summation Then format to match the pivot table best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MikeN" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table and Calculated Field
I've done that as a temporary solution, but I'm dealing with 3900 rows of
data in 300+ row fields, each with a different number of and (over time) a changing number of rows. So looking for a longer-term, dynamic solution, which I'm hoping exists in Pivot Table. "Bernard Liengme" wrote: Why not just add a formula (like =E24^2) next to the values and another to do the summation Then format to match the pivot table best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MikeN" wrote in message ... 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? |
Reply |
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) |