Alternate State whit Set Analysis

[Anonymous]

Hey Community,

im usin 3 group whit Alternate State and my problem is that i need to show at the Pivot table the sum of value for what was selected in each group from above,

e.g 

Group 1 > The client choose Country A and if he will choose formula 1 it will show formula 1, if he will choose formula 2 it will show 2 and if he choose nothing it will show 1+2 .

the same for all the groups.

Thanks in advance

[tresesco]

Try expression:

Sum({Group1}Value)+Sum({Group2}Value)+Sum({Group3}Value)

[#3]

look at attached qvw.

[sunny_talwar]

Can this also work (in all scenarios)?

Sum({Group1+Group2+Group3}Value)

[sunny_talwar]

Now that I think about it, the two expressions might give different output.

Sum({Group1}Value)+Sum({Group2}Value)+Sum({Group3}Value)

This will sum the Value twice or thrice if it comes into selection for two or three Groups.

Sum({Group1+Group2+Group3}Value)

This will only combine all the selection and show the Value once.

Did I interpret this correctly?

[Anonymous · Accepted solution]

I try this

=Aggr(Sum({Group1}CIF_PRICE_VALUE)+Sum({Group2}CIF_PRICE_VALUE)+Sum({Group3}CIF_PRICE_VALUE)+Sum({Group4}CIF_PRICE_VALUE)+Sum({Group5}CIF_PRICE_VALUE),COUNTRY,Period_DESC)

It must use agrr

[Anonymous]

Thank you but i use the function agrr becuse the sum was not correct for each country

but your help was more them ok !