4 Replies Latest reply: Sep 18, 2013 2:13 PM by MJ van der Meij RSS

    Problem combining AGGR and Set analyses. Always want to compare to same thing

    MJ van der Meij

      HI,

       

      I'm having problems with building a formula. This picture shows it best.

       

      case.png

       

      The CALC1 field should Always be the total of the productgroup: baseset.

      I've succeeded with doing that with for the first part with the formula
      SUM(TOTAL <[PRODUCTGROUP]> AMOUNT)

       

      Unfortunately I can't get it to work when the table hits the productgroup "Sales".

      See the picture.

      SUM(TOTAL <[PRODUCTGROUP]> {<PRODUCTGROUP={'BASESET'}>}AMOUNT) doesn't do the trick.

       

      I've included a .qvw file with script and GUI. Can anyone help? Thanks!