4 Replies Latest reply: Jan 28, 2014 12:29 PM by Fabrizio Zorer RSS

    Set Analysis

    Fabrizio Zorer

      Hello,

      someone can help me?

      I'd like to create a table like this:

      PARTNBR Week_26-29 Week_27-30 Week_28-31
      504129021109135152
      504129605312327371
      504129606633651659
      504129607931967992
      504129609247261268

       

      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