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

[#1]

HI,

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
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!

[CELAMBARASAN]

Hi,

Use CALC1 formula as

$(=SUM( {<PRODUCTGROUP={'BASESET'}>} AMOUNT) )

[Gysbert_Wassenaar · Accepted solution]

Use a helper variable. For example vTotal_BASESET: =sum({<PRODUCTGROUP={'BASESET'}>}AMOUNT)

See attached qvw.

[#4]

Thanks! That solves it!

I'm absolutely surprised to see that the formula does not work when coded into the expression, but that it does work when using a variable.

Thanks!

[#5]

oh wow. It seems I got 2 correct answers!

Thanks for this one too.