Group by Week Number

[MK_QSL]

I have below table…

LOAD

[Part Number],
[Qty Coming],
Date
FROM …file name…

I want this table to convert…

[Part Number] and [SUM OF QTY] per Week.

Week need to be displayed Dynamically based on Today().

Also, number of weeks are not fixed but it's starting from current week.

Sample file enclosed.....

Result table should be like below.

Part Number	Week	Sum of Qty Coming
A	37	250
A	38	200
A	39	150
A	40	180
A	42	90
B	38	150
B	40	50
B	42	260
C	37	300
C	38	450
C	39	500
C	40	700
C	42	600
C	43	200
C	44	250
D	40	150
D	42	250
D	43	350
D	44	450

[Gysbert_Wassenaar · Accepted solution]

I don't understand what you mean with: Week need to be displayed Dynamically based on Today().

See attached qvw. The week numbers match the example result table you posted.

If you want different week numbers you could substract the week of today for example: week(Date) - week(today()). As I said it's not clear to me what you want with regards to the week numbers. So you'll have to figure that out yourself. The attached qvw should get you started.