Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Please upload a sample
Might be
= Sum ({1<FAM_N_GIRO =>} AMOUNT)-sum(Amount)
If it will not help you Provide more information.
Regards,
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