Backlog end of week

[Anonymous]

Hello,

I have the following issue. Below a pivot table with backlog information of open orders. On week / day dimension you can see how many orders are open (Backlog End of Day). The open orders are the result of the created minus the invoiced order amount within the same time dimension.

What I want to realize is the backlog on the end of each week.The result will be 

7-6-2015 = 10500

14-6-2015 = 52705

21-6-2015 = 455

etc

What the correct set analysis for this problem?

Thanks

Robert

WeekY	Date	Creation	Invoiced	Backlog End of Day
2015/23	4-6-2015	10500	0	10500
	5-6-2015	0	0	10500
	6-6-2015	0	0	10500
	7-6-2015	0	0	10500
2015/24	8-6-2015	0	10500	0
	10-6-2015	16841	16841	0
	11-6-2015	52705	0	52705
	12-6-2015	0	0	52705
	13-6-2015	0	0	52705
	14-6-2015	0	0	52705
2015/25	15-6-2015	10880	63585	0
	18-6-2015	455	0	455
	19-6-2015	0	0	455
	20-6-2015	0	0	455
	21-6-2015	0	0	455
2015/26	22-6-2015	0	0	455
	23-6-2015	3418	-782	4655
	24-6-2015	29000	455	33200
	25-6-2015	12130	33200	12130
	26-6-2015	3744	0	15874
	27-6-2015	0	0	15874
	28-6-2015	0	0	15874
2015/27	29-6-2015	16675	0	32549
	30-6-2015	643	16675	16516

[Gysbert_Wassenaar]

The correct set analysis solution is not using any. See attached example.

[Anonymous]

Hi Gysbert,

Which example attachment??

[Gysbert_Wassenaar]

The one I attached in my previous post of  Aug 19, 2015 11:13 AM: