Grouping values for MultiBox

[sayadutt]

Hello Team,

I have a data list which shows a some values based on month.

Now my requirement is to create a MultiBox grouped by month names only

Example of my data:

2018_01_xxxx

2018_01_yyyy

2018_01_zzzz

2018_02_xxx

2018_02_yyy

2018_02_yyy

Now the MultiBox should show me below, grouped by Months

2018_01

2018_02

Thanks

[sunny_talwar · Accepted solution]

May be try an expression like this in the multibox

Left(FieldName, 7)

[Chanty4u]

orelse

keepchar(Filed,'0123456789_' )  as new

[sunny_talwar]

That will give

2018_01_ (an extra _ at the end)

[olivierrobin]

hello

do you absolutely need a multibox ?

one solution should be a listbox presented as a tree

but you need to change the 1st (or the 2nd) underscore by another character

[Chanty4u]

my bad i didnt notice last "_ "