Pivot table from dynamic refreshed pivot table

  • Thread starter Thread starter Michael.Tarnowski
  • Start date Start date
M

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
 
Thanks for the link, but I use Excel 2003 ;-(.

For my problem I found the solution:Pivotitems can be defined as
"running totals": Field settings > show as...
Click to expand...

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??
 
Back
Top