Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |