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

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" wrote:

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

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
"RandyWillaman" wrote in message
...

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" wrote:

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