Pivot Table

[Mathew P Bennett]

Good Evening Guys, 2007, I have this scrap beow of a pivot table I have
created, and wish to show a row named 'cost of sales' between rows 'direct
expenses' & 'overheads', being the result of 'Sales' less 'Purchases' less
'Direct Expenses'.

Is this possible? I am familar with calculated fields, but have scoured the
net for pointers, but am stumped.
Thank you, Mathew
(PS. I hope this scrap formatting works (I hate Word tables!!)


FIN_YR 08_09

Sum of Field1 MNTHNAME
NOMTOP 01_Feb 02_Mar 03_Apr 04_May 05_Jun Grand Total
1-Sales 0 0 0 0 0 0
2-Purchases 0 0 0 0 0 0
3Direct Expenses 0 0 0 0 0 0
4-Overheads 0 0 0 0 0 0
Grand Total 0 0 0 0 0 0

 

[RandyWillaman]

WHile not elegant, you could calculate the row within the source data (your
sales table) and then just pull that into the pivot table...

 

[Mathew P Bennett]

Thanks Randy, However I wish to keep my source data clean as it comes from a
refreshable MSQuery from a sagel50 dtabase, and the PT comes from that, (I
have to thinkof other users of this'real-time' info from the db). Thank you
for your reply. Mathew