PivotTables and Sum/Count 2 columns
 

I have an Excel worksheet with four columns; Relationship ID, Account Name,
Summary of Market Value and Account ID:

Realtionship ID Account Name Summary of Market Value Account ID
SEAR Sears $3250
20010
SEAR Sears $5345
20010
PENN Pennys $3236
20011
MARS Marshalls $4444
21222
MARS Marshalls $3244
21222

What I would like is to find the total count by Account Name with their
Individual and Total Revenue

I have created a PivotTable using Account ID in the Data field, and the rest
of the fields in the Row field, Relationship ID, Account Name, and Summary of
Market Value.

The PivotTable displays almost all of what I am looking for with the
Relationship Code - Total, Account Name and Sum of MarketValue per Account
name and then the final column contains the count of the Account ID. What I
am missing is the total of the Sum of MarketValue for each Relationship ID.

Is there a way of adding this?

Thanks

PivotTables and Sum/Count 2 columns
 

double click on the data botton (top left of the PT) and chante to SUM
instead to count

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Joey" escreveu:

I have an Excel worksheet with four columns; Relationship ID, Account Name,
Summary of Market Value and Account ID:

Realtionship ID Account Name Summary of Market Value Account ID
SEAR Sears $3250
20010
SEAR Sears $5345
20010
PENN Pennys $3236
20011
MARS Marshalls $4444
21222
MARS Marshalls $3244
21222

What I would like is to find the total count by Account Name with their
Individual and Total Revenue

I have created a PivotTable using Account ID in the Data field, and the rest
of the fields in the Row field, Relationship ID, Account Name, and Summary of
Market Value.

The PivotTable displays almost all of what I am looking for with the
Relationship Code - Total, Account Name and Sum of MarketValue per Account
name and then the final column contains the count of the Account ID. What I
am missing is the total of the Sum of MarketValue for each Relationship ID.

Is there a way of adding this?

Thanks

PivotTables and Sum/Count 2 columns
 

Thank you but that just changes the Account ID totals to 0. I am looking for
the totals of the Market Value

"Marcelo" wrote:

double click on the data botton (top left of the PT) and chante to SUM
instead to count

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Joey" escreveu:

I have an Excel worksheet with four columns; Relationship ID, Account Name,
Summary of Market Value and Account ID:

Realtionship ID Account Name Summary of Market Value Account ID
SEAR Sears $3250
20010
SEAR Sears $5345
20010
PENN Pennys $3236
20011
MARS Marshalls $4444
21222
MARS Marshalls $3244
21222

What I would like is to find the total count by Account Name with their
Individual and Total Revenue

I have created a PivotTable using Account ID in the Data field, and the rest
of the fields in the Row field, Relationship ID, Account Name, and Summary of
Market Value.

The PivotTable displays almost all of what I am looking for with the
Relationship Code - Total, Account Name and Sum of MarketValue per Account
name and then the final column contains the count of the Account ID. What I
am missing is the total of the Sum of MarketValue for each Relationship ID.

Is there a way of adding this?

Thanks