View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mathew P Bennett Mathew P Bennett is offline
external usenet poster
 
Posts: 49
Default Pivot Table Calculated Field Row - (For Balance Sheet)

Good Evening Guys, Excel 2007 & still geting to grips with it after years of
2000/2003!
Pivot Table query. I have via MSQuery of Sage line50 managed to produce a
balance sheet pivot table of sorts.(so far). I Have current assests (with
subtotal) & current liabiities (with subtotal), but wish to insert a
caculated row of 'Nett Current Assets', ie the diff of the two subtotals,
but above the 'Cap & Reserves' rows.

I hope I have not made this too 'accountany', but any help with this
calulated row would be most appreciated.
Cheers, Mathew