Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to merge different rows in a single row.
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.
Answers
-
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
0 -
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.
Hope this helps.
Thanks
Dimple Nagesh
0 -
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.
Hope this helps.
Thanks
Dimple Nagesh
0 -
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.
Hope this helps.
Thanks
Dimple Nagesh
0
