yes you can create. once you use any field in a calculated field it become a part of your dimension/measure.
Can you share any material regaridng your requirement?
I am unable to share - due to non-disclosure agreements.
Anyways, have you looked at the script which I have written above? Are you certain this is possible - for I have tried it and there seems to be an error with my script.
Hi @Ram Asokan,
I have done the calculation which you were looking for, Just go through the attached sheet.
Instead of using IF Statement I have used CASE .. I hope this helps. Please mark correct if this is what you were looking for. Thank you!!
Service Wise Revenue.twbx 12.4 KB