M
Mathew P Bennett
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
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