Multiple Alternate States in a Chart

[Anonymous]

I am creating a chart with multiple expressions that each exist in a separate state.  I have included the example below:

=Sum({[Chart 1]} [Total Spend])

They all work fine, but I wanted to add on a simple field =Fieldname on the end.  Those aren't working with the alternate states the same way.  I was trying =({[Chart 1]} Fieldname) but that was coming up as an error. 

Does anyone know how to write this?

[Clever_Anjos · Accepted solution]

try using Only() function

=Only({[Chart1]}Fieldname)

[sunny_talwar]

Hey Jeremy -

How are you? Are you looking for this?

=Sum({[Chart 1]} [Total Spend]) & ' ' & Only({[Chart 1]} Fieldname)

[Anonymous]

Thank you very much Sunny.  I will check to see if this will work.