View Single Post
  #3   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

Thanks for the suggestion.

However, I don't think that would do it. If the income is sales invoices and
the expenditure purchase invoices, then they don't necessarily match up
individually - they only match up when aggregated.

"Eduardo" wrote:

Hi,
Yes you are correct, what you can do is to have another column in your file
with the difference and then you can include it in the Pivot table

hope this helps

"DRW" wrote:

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.