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?