Excel Report Cashflow Calculation

[Robert Moffat]

I have used the reporting function in Microsoft Project (MP) to generate a
cashflow in Excel, based on a cost input column as part of the gantt in MP.
MP allows me to set the gantt display to fiscal quarters. I can therefore
show that the first quarter corresponding to the financial years I need to
report on starts in July.

The problem is that the cashflow generated in Excel doesn't correspond to
the financial year I set up starting with July as the first quarter. It uses
cost from January to March for the first quater cashflow projection.

How do I get the quarters of Excel pivot table to correspond to that
displayed in the gantt ?

Please help

Regards Robert

 

[Rod Gill]

I don't think that reporting function does fiscal time. I think you will
need a custom VBA macro to do this.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com