Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 290 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 112 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to Pivot the record and dynamically include the columns
User_C0O9W
Rank 1 - Community Starter
Hi,
Am BI resource and new to Oracle. I have a requirement to create a view for reporting.
View column template is attached. Product and Item level records are stored in row level in DB tables. But for reporting, I need to display the Product and Item level at Column level (From column E) and based on Product count and Item count, the column should get included dynamically in view. Please suggest to achieve this logic.
Thank you!
0