Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
try using Only() function
=Only({[Chart1]}Fieldname)
Hey Jeremy -
How are you? Are you looking for this?
=Sum({[Chart 1]} [Total Spend]) & ' ' & Only({[Chart 1]} Fieldname)
Thank you very much Sunny. I will check to see if this will work.