balance in pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

we are importing a pivot table from column c & d How an we configure colun c minus column d
 
DK

Pivot tables have column headings (fields). If you go to the pivot table
toolbar, select Formulas>Calculated Field... and fill out your formula here
it will make a new field alongside the other two columns that can be
manipulated as any other field

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)


dk said:
we are importing a pivot table from column c & d How an we configure colun
Click to expand...
c minus column d
 
As we don't understand please explain:
We have a column Of gain & we have a column Of Expense the expense is not on the same row of the gain can be even 10 rows ahead now when e create the pivot table both columns are going to be sum of gain & sum of expense we couldn't find were to put calculated field for subtracting one from the other to have a subtotal from gain
 
DK

Sorry, I am not understanding your reply. Can you perhaps send me a small
sample of the data. Take out the obvious bits from the email

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)


dk said:
As we don't understand please explain:
We have a column Of gain & we have a column Of Expense the expense is not
Click to expand...
on the same row of the gain can be even 10 rows ahead now when e create the
pivot table both columns are going to be sum of gain & sum of expense we
couldn't find were to put calculated field for subtracting one from the
other to have a subtotal from gain
 
Back
Top