I have this tab, and I want it to show the total sum only if I select one user (resource). is it possible?
You can put: GetSelectedCount(Resource)=1 in the Conditional show of your chart. Then add a Resource listbox.
Check out this expression
If(GetSelectedCount(Resource) <> 1, If(Dimensionality() > 0, Sum([% Resource])), Sum([% Resource]))
Retrieving data ...