Display dimension values in Text object

[pinky1234]

Hi,

I have data like in table below. I want to display location in Text object like if you select rank 111 or Rack or any associated field from search object text object should show location as Michigan, Select 121 show Ohio, Select  131 show California..etc. If i don't select anything show text objects as empty. 

Location	Rank	Rack
Michigan	111	A
Ohio	121	B
California	131	C
Chicago	141	D

[Kushal_Chawda]

@pinky1234  you can simple call, =Location text object

[pinky1234]

I tried that way and it didn't work. Even i tried Concat function but all locations are showing in text object.

[QFabian]

hi, in a text object try :

=only(Location)

as is possible to have more than one Michigan value location

[pinky1234]

I tried only function and it didnt work.

[MayilVahanan · Accepted solution]

Hi @pinky1234 

Might be, you have more than one location per rank or rack.
Try like below

=if(GetselectedCount(Rank)=1 or GetSelectedCount(Rack)=1, Count(Distinct Location, ','), '')