Pivot Table and Calculated Field

[MikeN]

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?

 

[Bernard Liengme]

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

 

[MikeN]

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.