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
|