LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DRW DRW is offline
external usenet poster
 
Posts: 4
Default Pivot table - deducting sub-totals of income and expenditure

In Excel 2007, I use pivot tables to analyse income and expenditure.

I would like to be able to deduct the expenditure from the income, but Excel
seems to only provide an addition for Grand Totals, not the ability to deduct.

Any suggestions gratefully received.

Many thanks.
 
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 do i set up an income and expenditure account in excel? Novice24 Excel Worksheet Functions 0 October 9th 07 10:33 PM
I'm looking for an income expenditure budget sheet in excel please danny Excel Discussion (Misc queries) 1 March 2nd 07 10:50 PM
Pivot Table Chart - With Pivot Table Totals WCM Charts and Charting in Excel 0 November 29th 06 03:21 PM
personal income and expenditure chart mikeyboy87 New Users to Excel 1 December 14th 05 03:35 PM
is there a template for an income and expenditure statement in Ex. soak93 Excel Discussion (Misc queries) 1 February 27th 05 11:55 PM


All times are GMT +1. The time now is 11:51 AM.

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

About Us

"It's about Microsoft Excel"