Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OAS 2025 setting aggregation to none removes all row level data.
Hi Team,
Issue steps:
- In the report's criteria tab, full table totals are displayed for all columns.
- For one particular column, we do not required the total (SUM) to be shown.
- To achieve this, we set the column's aggregation to 'None'.
- However, after this change, the report is not just removing the total - it is also removing or blanking out all individual row values for that columns.
EXPECTED BEHAVIOR :
- The column should display row-level values as-is.
- Only the total (aggregate row) should not display any value for that column.
Workaround
Confirmed that the behavior being seen for Excluded Column with respect to aggregation is an expected behavior.
Suggested to Use the Hidden Option instead of the Excluded option as a workaround.
Thanks & Regards
Syed Ameer Sohail
+91-9108234874
Comments
-
Exploring on using Excluded column option while using Aggregation on the columns
1