Grand Substraction instead of Grand Total in pivot table

[Newbie]

Hello,
I created a pivot table in Excel with Visual Report 2007. I'm using an
Outline Code with 2 leaves : Receipts and Expenses.
The pivot table created automatically a Grand Total so that $1000 Receipts
and $800 Expenses => Grand Total = $1800.
My accountant says $200.
Generally, it's possible to create calculated fields in the Excel pivot
tables. But in the pivot table created by the Visual Reprot, all the
Calculated Field options are greyed out.
Why ?
Thanks for any help

 

[Nick Hodge]

I don't know what visual report is, but suspect that it would be more a
question for them not Excel as it appears their 'application' is taking over
some Excel functionality

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Newbie]

Hi Nick,
Visual Reports is a feature of Microsoft Project 2007. It generates reports
into Excel 2007, especially pivot tables.

 

[Nick Hodge]

Same applies then, I would post in a Project group as they will likely be
using this feature far more than anyone in Excel

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk