Categories
- All Categories
- Oracle Analytics Learning Hub
- 17 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 84 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Reports - Export Aggregated Data into Excel, Clean expression not maintained

Abbey Seeber
Rank 1 - Community Starter
Description
When you export aggregated data with an applied clean expression into excel the data no longer remains aggregated and each piece of data is entered into it's own cell.
Use Case and Business Need
When you export aggregated data into excel the data no longer remains aggregated and each piece of data is entered into it's own cell. This makes it almost impossible to sort your data or manipulate it once it is in Excel. We have found a lot of problems when it comes to our AAP reporting and using the field titled Aggregated Requisition Owners. The clean expression that you can add will help the report generate correctly to view but once you export, it is lost.
Original Idea Number: 38ef6915a0
1