Lumira Designer 2.1: how to aggregate/group a field per its text, not per the key (default)

[former_member323943]

Hello Experts,

I'm using a BW Query as the data source in Lumira Designer 2.1, the values inside one of the dimensions just like the following:

1001 Plant A

1003 Plant A

1007 Plant B

1010 Plant B

My business requirement wants this dimension should be grouped/aggregated per the same "text", e.g. Plant A or Plant B, not per its "key", e.g. 1001, 1003... And then we can use different charts to demonstrate the data later.

How can we achieve this? or is it possible to achieve this in Lumira Designer 2.1, or per the scripting code?

Thanks!

Tony