Project 2007 Visual Reports Question

[Leslie W.]

Good Afternoon!

Question regarding Visual Reports:

I like to export data into Excel to create custom reports, however, when I
export the data, I would like the dates to order in regards to fiscal year,
rather than calendar year. Is that possible? Excel, as far as I understand,
only understands calendar year?

Thanks!

 

[John Garay - DecisionEdge]

Hi Leslie,

How are your fiscal years defined?
Do you have fiscal calendar information stored in a different field in
Project?

Regards, John Garay

 

[Shana C.]

Johm or Leslie,
I am also interested in this question. I am trying to generate a cost flow
report and another cost versus time visual report in excel using the pivot
table and can not figure out how to get excel to use the fiscal year instead
of the calendar year. The timescale in my gantt chart is correct (with
regards to the fiscal year), but my cost flow report is based on calendar
years/quarters. Please help if you know how to do this!


Thanks,
Shana Cole