[Ollie]

You are right,
in query pane it works fine.
we are trying to do use select statement in the calculated member pane and it is not working. make sence.

thank you.
O.