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

[sunny_talwar]

Something like this?

[sunny_talwar]

Or this

SiteView:

LOAD * INLINE [

    Site

    AD-K (A)

    AD-K (B)

    AD-K (C)

    AD-K (D)

    AD-H (S)

    AD-H (T)

];

SiteTree:

LOAD Site,

SubField(Site, ' ', 1) & '/' & Site as SiteTree

Resident SiteView;

Concatenate(SiteTree)

LOAD Site,

SubField(Site, ' ', 1) as SiteTree

Resident SiteView;

[Anonymous]

Yes, but it is possible to create this view with a formula in listbox?

[sunny_talwar]

May be using this

=If(Len(Trim(Site)) > 0, SubField(Site, ' ', 1) & '/' & Site)

[Anonymous]

Great. If i have more values like AS and AD in listbox, and only AD-K and AD-H will show in listbox. How is this formula?

[sunny_talwar]

May be this

SubField(Site, '-', 1)

[sunny_talwar]

What exactly are you wish to see in the list box?

[Anonymous]

Listbox should be filtered by: AD-K and AD-H

[sunny_talwar]

So you don't want to see AD and AS in site listbox?