Total Sum only if one item selected

[silvia_assuncao]

Hi Everyone,

I have this tab, and I want it to show the total sum only if I select one user (resource). is it possible?

thanks

[m_woolf]

You can put:  GetSelectedCount(Resource)=1 in the Conditional show of your chart. Then add a Resource listbox.

[sunny_talwar]

Check out this expression

If(GetSelectedCount(Resource) <> 1, If(Dimensionality() > 0, Sum([% Resource])), Sum([% Resource]))

[silvia_assuncao]

great!

thanks