Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 14th 04, 03:57 AM
dha17
 
Posts: n/a
Default 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




  #2   Report Post  
Old December 15th 04, 05:39 AM
Gary Rowe
 
Posts: n/a
Default

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a pivot table if the pivot table icon or menu ite. [email protected] Charts and Charting in Excel 1 December 16th 04 02:36 AM
Pivot table help:calculated field based on previous consecutive va martin Excel Discussion (Misc queries) 0 December 9th 04 08:33 PM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 09:39 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM
convert excel list to pivot table GI Excel Discussion (Misc queries) 0 December 6th 04 06:45 PM


All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017