Help with MULTI BOX

[hopkinsc]

Hello,

I have a MULTI BOX with various selection criteria.

One of the selections is called CUSTOMER SCANNING VERSION, the end user can then select from the following

10.33

10.331

10.333

10.334

10.3318

10.51

10.52

10.525

10.529

10.5214

10.5218

All of these fields are needed, but i would like to make the end user experience easier by grouping all 10.33 together and 10.52 togaether.

Meaning that the end user can just click on 10.33 which will display all data relating to 10.33, 10.331, 10.333, 10.334 and 10.3318.

Can anyone help me do this please?

[nathanfurby]

Like this:

LOAD

[Customer Group],
[Retail Group],
[Customer Scanning Version],
LEFT([Customer Scanning Version],4) AS VersionGroup

FROM $(cfilename) (qvd);

[hopkinsc · Accepted solution]

Thanks, for some reason it didn't work in my script, It blanked out some other fields.

But i tried it in an expression in my multi box and it worked great.

Thanks for your help 🙂