XP Pivot Tables - my nemisis
 

I have a spreadsheet with three columns - column A is filled with company
names (not unique), column B are the fees they've paid to all vendors, and
column C are the fees that they've paid to us.

So I make a pivot, such that column A will have unique company names. Then
I drag the Vendor fees into the table such that I see the total sum paid by
each company to all vendors. Then, ideally, I would like another column to
the pivot table which sums up the total fees paid to us.

Is this possible? Currently we've been achieving this with two identical
pivots, which seems a waste of time.

Thanks in advance
Daniel

Hi Daniel,

Set up a pivot table with company names in the row area, vendor fees and
your fees in the data area.
Then drag the headings in the data area until you get two columns
side-by-side.

See my pivot table tutorial at http://edferrero.m6.net/tutorials.html for
further info.

Ed Ferrero


"Daniel Bonallack" wrote in
message ...
I have a spreadsheet with three columns - column A is filled with company
names (not unique), column B are the fees they've paid to all vendors, and
column C are the fees that they've paid to us.

So I make a pivot, such that column A will have unique company names.
Then
I drag the Vendor fees into the table such that I see the total sum paid
by
each company to all vendors. Then, ideally, I would like another column
to
the pivot table which sums up the total fees paid to us.

Is this possible? Currently we've been achieving this with two identical
pivots, which seems a waste of time.

Thanks in advance
Daniel

Thanks! So simple, yet saves us so much time.
Is it true that there is a limit (of 15 fields)?

"Ed Ferrero" wrote:

Hi Daniel,

Set up a pivot table with company names in the row area, vendor fees and
your fees in the data area.
Then drag the headings in the data area until you get two columns
side-by-side.

See my pivot table tutorial at http://edferrero.m6.net/tutorials.html for
further info.

Ed Ferrero


"Daniel Bonallack" wrote in
message ...
I have a spreadsheet with three columns - column A is filled with company
names (not unique), column B are the fees they've paid to all vendors, and
column C are the fees that they've paid to us.

So I make a pivot, such that column A will have unique company names.
Then
I drag the Vendor fees into the table such that I see the total sum paid
by
each company to all vendors. Then, ideally, I would like another column
to
the pivot table which sums up the total fees paid to us.

Is this possible? Currently we've been achieving this with two identical
pivots, which seems a waste of time.

Thanks in advance
Daniel