How to combine fields in a report as one column?
I am generating a report for all Change requests for a given release number. Release number is a custom field.
I have a scenario where I have three fields Environment 1, 2,3 containing Prod, Test and Mock values. And they have corresponding implementation dates as well. I need to grab only the field which has 'Prod' value and corresponding implementation date field value. All these are custom fields.
I tried custom expressions but there are limitations. Using the advanced query option messes up the parameters.
Any suggestions.