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



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




      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


      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!