Remember Me?

 dha17 Posts: n/a How to create a calculated field formula based on Pivot Table resu

Hi,

I have a simple Pivot Table consisting of:

Row Section (column A): Name
Column Section (column B, C and D): Courses (X, Y, Z)
Data Section: Is the MIN test scores for the course.

For Example:
John 8 5 7

I am trying to add a Calculated Field to the Pivot table to SUM all of the
test scores shown in the Pivot Table results. The problem is that the
calculated field SUMs ALL of the test scores in my data, not just the ones
shown in the Pivot Table (which is the MIN for each course).

What I Want (the SUM of the test scores shown in the Table):
John 8 5 7 20

What I Get (the SUM of all test scores in the database):
John 8 5 7 55

I have tried the following formulas in my Calculated Field and both yield
the undesired result:

=SUM(X,Y,Z)
=SUM(MIN(X), MIN(Y), MIN(Z))

Denny

 Gary Rowe Posts: n/a I think you will have to create your sum outside of the pivot table.

"dha17" wrote:

Hi,

I have a simple Pivot Table consisting of:

Row Section (column A): Name
Column Section (column B, C and D): Courses (X, Y, Z)
Data Section: Is the MIN test scores for the course.

For Example:
John 8 5 7

I am trying to add a Calculated Field to the Pivot table to SUM all of the
test scores shown in the Pivot Table results. The problem is that the
calculated field SUMs ALL of the test scores in my data, not just the ones
shown in the Pivot Table (which is the MIN for each course).

What I Want (the SUM of the test scores shown in the Table):
John 8 5 7 20

What I Get (the SUM of all test scores in the database):
John 8 5 7 55

I have tried the following formulas in my Calculated Field and both yield
the undesired result:

=SUM(X,Y,Z)
=SUM(MIN(X), MIN(Y), MIN(Z))

Denny

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post [email protected] Charts and Charting in Excel 1 December 16th 04 02:36 AM martin Excel Discussion (Misc queries) 0 December 9th 04 08:33 PM Mike -Z- Charts and Charting in Excel 1 December 7th 04 09:39 PM souris Charts and Charting in Excel 2 December 7th 04 03:56 AM GI Excel Discussion (Misc queries) 0 December 6th 04 06:45 PM

All times are GMT +1. The time now is 07:12 PM. Copyright ©2004-2021 ExcelBanter.