Calculate events during a certain period

Originally Posted by oeldere

reply to your question in #10

If you add new data in your table and refresh the pivot table you have the total of the item during the year (and the total per week).

Hi Oeldere,

When you update the pivot table you will have the same problem, because you use a column to define which is the present week,
the ones that are not return 0 " =IF(D27=1;$H$25;0) "
the pivot table will not hold the values for the past weeks, or are you suggesting a different approach?