Sum function

[Anonymous]

Good day!

I made a bar graph and on measure put the following function:

= Sum ({<FAM_N_GIRO =>} AMOUNT)

And I see two bars: one for "Market" and the other for the family that I select, but in the "amount" for "market" I omit the amount of the selected family.

My question is: How can I do so that in "Market" I see the total of all families and apart from the family selected?

[sasiparupudi1]

Please upload a sample

[PrashantSangle]

Might be

= Sum ({1<FAM_N_GIRO =>} AMOUNT)-sum(Amount)

If it will not help you Provide more information.

Regards,

[thevingo]

Hi

but in the "amount" for "market" I omit the amount of the selected family

How you do that, please explain.

Now for How can I do so that in "Market" I see the total of all families and apart from the family selected?

You can try e() in SET expression as

=Sum ({<FAM_N_GIRO = e(FAM_N_GIRO)>} AMOUNT)

--please check the syntax

govind