Grand Substraction instead of Grand Total in pivot table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Newbie - 05 Jan 2007 22:45 GMT

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

Reply to this Message

Nick Hodge - 06 Jan 2007 07:48 GMT

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

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk

> Hello,
> I created a pivot table in Excel with Visual Report 2007. I'm using an
[quoted text clipped - 7 lines]
> Why ?
> Thanks for any help

Reply to this Message

Newbie - 06 Jan 2007 12:37 GMT

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

> 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
[quoted text clipped - 11 lines]
> > Why ?
> > Thanks for any help

Reply to this Message

Nick Hodge - 06 Jan 2007 13:04 GMT

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

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk

> Hi Nick,
> Visual Reports is a feature of Microsoft Project 2007. It generates
[quoted text clipped - 18 lines]
>> > Why ?
>> > Thanks for any help

Reply to this Message