map tree

[fmazzarelli]

Hi Community,

how to group the entries that contain a number?

I want to group all the items (a51351, f50092, e50050, a51047)  in a single voice.

THE END RESULT SHOULD BE A TREE MAP WITH THE VOICES

ASSCLI

ASSREM

SPES16

ORDER  which includes A51351, F50092, E50050, A51047

[Gysbert_Wassenaar]

Try this as calculated dimension: If(len(KeepChar(VOICE, '0123456789')), 'ORDER', VOICE)