Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to name my chart whatever the current selection is but only to the last selection made. So, I have Zone, Unit, Product. I was my initial title to say "Score", then once I've selected Zone, I want it to say "Score Zone" (whatever the zone is they've selected), once a unit is selected it needs to read "Score Unit", therefore ignoring the Zone. Ideas?
Kev
Then u have to mix mine and kushals code
That only pulls down the field name, not the value
Try like:
='Score '& GetCurrentField(DrillGroupName) &': ' & $(=GetCurrentField(DrillGroupName))
'Score '& if( getselectedcount(Zone)>0, Concat(distinct Zone,',') & ' ' &subfield(GetCurrentSelections(),':',1),'')
Try this for Zone