This content has been marked as final. Show 3 replies
Yeah you can go with new logical column with expression and can use it for hierarchy so that you can treat it as one of the level.
ex: drill down column value LCD on click on that you can see LCD1, LCD2 etc..
Try to see the valid expression to define new column.
If helps pls mark
thanks I think it will work if I create a new logical column using regular expression. Is there any other way for this problem? Because I think it will be very slow
Handle it during with ETL.. there wont be any performance issues..1 person found this helpful
Appreciate if you mark as correct/helpful :)