Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think this works:
sum({<week={$(=concat(distinct week-2,','))} >} Q_rich)
What could be your selection to get this result?
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
I think this works:
sum({<week={$(=concat(distinct week-2,','))} >} Q_rich)
Thank you very much! It works!