Need help splitting column of data into two columns by filtering on another columns values.

[remedibi]

In the below image you can see I am receiving duplicate rows of data for each TP# involved. What I want to do is make two columns called Request SLA and Response SLA (as shown in column C). The data I want to fill the fields with is in Column B. Rather than using a pivot table I thought that maybe there is a easier way by only showing rows where column C is Request SLA then make another field and only show data where the column value is response SLA. I am unsure what the syntax would be in the field expression.

[bramkn]

Field1:
only({<CustomFieldname={"Request*"}>}CustomFieldName)
Field2:
only({<CustomFieldname={"Response*"}>}CustomFieldName)
should work.

[remedibi]

I am seeing a invalid dimension error when viewing my table. Is this because it is not recognizing one of my fields in the expression? When building the expression it does not show any errors which is great!

Thanks

[bramkn]

its not a dimension. Create a measure instead.

[remedibi]

This seems to be tricky. In order for the SLA to show I will need the corresponding value from the CustomFieldName to show as well. The problem is I need both values to appear on the same row of data. But doing so at the moment I believe I would need both SLA CustomFieldNames to be present on the report at the same time as well.

[remedibi]

Is it maybe possible to do a similar for XML path type of function?

[bramkn]

ah you want the data with the name whoops:
Request SLA:
only({<CustomFieldname={"Request*"}>}CustomFieldData)
Response SLA:
only({<CustomFieldname={"Response*"}>}CustomFieldData)