Group Site in ListBox

[Anonymous]

Hello,

in a list box same values should be grouped. Can a tree structure be realized with a formula?

AD-K

  AD-K (A)
  AD-K (B)
  AD-K (C)
  AD-K (D)

AD-H

AD-H (S)
AD-H (T)

Regards

Stefan

[Anonymous]

Yes, i don't want to see AD and AS.

[sunny_talwar · Accepted solution]

May be this

=If(Len(Trim(Site)) > 0 and Match(Site, 'AD', 'AS') = 0, SubField(Site, ' ', 1) & '/' & Site)

[Anonymous]

Now it's working fine. Many Thanks for you help.

Also working:

=If(Left(Site,3)='AD-', SubField(Site, ' ', 1) & '/' & Aggr(Only({<site = {'AD-K*', 'AD-H*'}>} Site), Site))