For OTBI Analysis not getting data in correct format
I am trying to built a analysis bases on 2 Subject areas Project Billing Revenue real time and Project costing Actual cost Real Time, this issue is like I am trying to fetch Revenue Amount and Cost based on Contract Number. I am getting the data for each column but I need that the data should reflect in one column.
The Revenue amount, Concatenated Segments that is highlighted must be in same line that for Contract Line Number.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):