How to merge different rows in a single row.

Yashdeep

I am trying to create one report based on Revenue generated and actual cost, so I am fetching revenue amount and cost for that particular project number, getting the correct data but I want it in a single line.

The row value for Expenditure type , Cost and Raw cost account needs to be in single line.

Rajasekhar Bandaru-Oracle

Please try to use the concat option to merge both column's data. Refer to the doc

https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/edit-formulas-or-calculated-measures.html

Dimple-Nagesh-Support-Oracle

Hi Yashdeep,

Thanks for submitting your request in Reporting and ANalytics.

Please try the following: Go to Results -> Edit View ->Table

Click on the XYZ, then check Hide Content (show sections only)

Now open the report in the view mode (not the edit mode)

The table view is hidden.

Table_Properties.png

Hope this helps.

Thanks

Dimple Nagesh

Dimple-Nagesh-Support-Oracle

Hi Yashdeep,

Thanks for submitting your request in Reporting and ANalytics.

Please try the following: Go to Results -> Edit View ->Table

Click on the XYZ, then check Hide Content (show sections only)

Now open the report in the view mode (not the edit mode)

The table view is hidden.

Table_Properties.png

Hope this helps.

Thanks

Dimple Nagesh

Dimple-Nagesh-Support-Oracle

Hi Yashdeep,

Thanks for submitting your request in Reporting and ANalytics.

Please try the following: Go to Results -> Edit View ->Table

Click on the XYZ, then check Hide Content (show sections only)

Now open the report in the view mode (not the edit mode)

The table view is hidden.

Table_Properties.png

Hope this helps.

Thanks

Dimple Nagesh