Pivot Table - Monthly time series

V

Verossa

Hi All

I have a list of tasks, task start / finish date and costs. Here's an extract

Start End Cos
Refine Work Plan 03/15/04 03/26/04 500
Define Project 03/22/04 03/22/04 50
Issue Plan 03/23/04 03/24/04 100
Risk Management Plan 03/25/04 03/26/04 100
CM Plan 03/26/04 03/26/04 50
P / M Standards 03/29/04 03/29/04 50
Create Quality Plan 03/30/04 04/02/04 200
Management Strategy 04/02/04 04/02/04 50
Software Requirements 04/05/04 04/05/04 50

Question: I want to create a pivot table with the tasks on the left and cost as the data. However, I want to capture the data by month. Can this be done with the pivot table feature

TIA to all who respond
Vers
 
F

Frank Kabel

Hi
not quite sure how your result would differ from your current layout
8besides hiding start and end dates). You only have (based on your
current example) one cost item per item. Questions:
- do you want to split the costs per month?
- do you want to enter costs per month (in additional columns)

For both alternatives I don't think pivot tables are feasible :)
You may post an example result based on this source data (also plain
text - no attachment please)

--
Regards
Frank Kabel
Frankfurt, Germany

Verossa said:
Hi All,

I have a list of tasks, task start / finish date and costs. Here's an extract:

Start End Cost
Refine Work Plan 03/15/04 03/26/04 5000
Define Project 03/22/04 03/22/04 500
Issue Plan 03/23/04 03/24/04 1000
Risk Management Plan 03/25/04 03/26/04 1000
CM Plan 03/26/04 03/26/04 500
P / M Standards 03/29/04 03/29/04 500
Create Quality Plan 03/30/04 04/02/04 2000
Management Strategy 04/02/04 04/02/04 500
Software Requirements 04/05/04 04/05/04 500

Question: I want to create a pivot table with the tasks on the left
Click to expand...
and cost as the data. However, I want to capture the data by month.
Can this be done with the pivot table feature?
 
Top