Set Analysis

[#1]

Hello,

someone can help me?

I'd like to create a table like this:

PARTNBR	Week_26-29	Week_27-30	Week_28-31
504129021	109	135	152
504129605	312	327	371
504129606	633	651	659
504129607	931	967	992
504129609	247	261	268

related with the following selection:

where i.e. 109 is the total volume (Q_rich) of the partnbr between the week 26 and 29.

Which is the correct syntax of the expression "sum( {$<week =  {(week)-2} >} Q_rich )" of the column week_26-29?

Thank you in advance

[MK_QSL]

What could be your selection to get this result?

[#3]

I'd like to compare the result i get calculating the expression with the selection 28-31 (week)  with the result I get with the selection 27-30 and 26-29, maintaining the selection

week

[Anonymous · Accepted solution]

I think this works:

sum({<week={$(=concat(distinct week-2,','))} >} Q_rich)

[#5]

Thank you very much! It works!