| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
