expression based on dimension

[Anonymous]

Can I calculate the expression depending on the Dimension value.

For example is the Country is US I want the sum but if Others I want empty:

So from :

to

Many thanks,

Raphael

[rubenmarin · Accepted solution]

Hi Raphael, in this sample can work with this expression:

If(Country = 'US', sum(Score), '')

[Anil_Babu_Samineni]

May be this?

=If(Country = 'US', Sum(Score), '')