Changing Numerical Values(Measures) into Text in Table in SAC

[stuzer]

Dear all,

We are trying to create a table looking like this.

However, On query level we couldnt achieve to work with Company as text so we assigned them Ids to be able to define them as measures and us it our query.

As a result, The table looks like this on SAC.

Our struggle is to convert these values to text again in new Story2 or analytics designer. As we dont have many company types, it doesnt need to be dynamic.In other words, updating the table on initial load by reading it as array/List and updating the values.

Did anyone try something similar?

Thanks in advance.

[dewikarao]

Hello, were you able to solve this problem? We have a similar requirement now. Thanks!