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