Adding a calculated field to a dimension

[Anonymous]

Hi Everybody

I have this data-set where I have some dimensions. Within one of those dimensions I want add a calculated field, based on two fields in that dimension.

Please se attached example. Trying to do it with Left Join and Resident in the script function.

Is it possible in any way?

Regards

Stefan

[Kushal_Chawda]

Have you tried this? It's working for me

[Anonymous]

That worked exactly like I wanted too

Thanks a lot. You just saved me a lot of time.

Regards

Stefan

[Kushal_Chawda]

Awesome