Pivot table from dynamic refreshed pivot table

[Michael.Tarnowski]

Hi community,
I want to track action items: closed, open, overdue, and postponed
activities. For this I defined a tracking sheet holding all actin
items - defined as dynamic range and an associated pivot table with
the structure showed in http://www.michaeltarnowski.de/temp/pivot.jpg

This pivot table is fed by the data of the dynamic range and refreshes
automaticaly when the sheet is activated and charted. The problem with
that this table shows for each week the sum of closed, open, overdue,
and postponed items only. But, in real life all open issues of the
last week which are not closed in the meantime remain open in the
ongoing week, i.e. the open issues of the ongoing week are the sum of
all open items of this week plus the sum of open issues of the
foregoing week. This is valid for overdues and postponeds as well, but
not for closed items.

How can rearrange this table or define a new pivot table showing the
behaviour intended? - Do I need a pivot table of a pivot table?
Thanks for your assistance, have a nice day
Cheers Michael

 

[Herbert Seidenberg]

Excel 2007
Here is a general schedule that uses
PivotTable to count project statuses
Gantt chart included.
http://www.mediafire.com/file/ir5y5xy2jdj/01_20_09.xlsx

 

[Michael.Tarnowski]

Excel 2007
Here is a general schedule that uses
PivotTable to count project statuses
Gantt chart included.http://www.mediafire.com/file/ir5y5xy2jdj/01_20_09.xlsx

Thanks for the link, but I use Excel 2003 ;-(.

For my problem I found the solution: Pivot items can be defined as
"running totals": Field settings > show as...

 

[Prixt0n]

Thanks for the link, but I use Excel 2003 ;-(.

For my problem I found the solutionivotitems can be defined as
"running totals": Field settings > show as...

I succeeded to get it to work!! But I had to make a copy of the data
sheet into a new workbook.

This can not be the rightway to do it but it works - Bug??