#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 49
Default Pivot Table

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


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Pivot Table


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



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 49
Default Pivot Table

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create pivot table from existing pivot table in excel 2007 Udayraj Dhulekar Excel Discussion (Misc queries) 2 July 8th 13 08:22 PM
Copying values from pivot table to cells outside pivot table richzip Excel Discussion (Misc queries) 4 January 16th 08 11:03 PM
Filter lines with Pivot table and non pivot table columns Grover Charts and Charting in Excel 4 September 28th 07 03:16 AM
Filter lines with Pivot table and non Pivot table columns Grover Excel Discussion (Misc queries) 1 September 26th 07 12:48 AM
How do I create a pivot table if the pivot table icon or menu ite. Lynn@WS Charts and Charting in Excel 1 December 16th 04 02:36 AM


All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"