Categories
- All Categories
- 121 Oracle Analytics News
- 21 Oracle Analytics Videos
- 14.4K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
Reports - Export Aggregated Data into Excel, Clean expression not maintained
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
Comments
-
Abbey,
could you please illustrate this with an example using screenshots and excel output?
Thanks
Raghu0 -
When it gets into Excel, you have to click Wrap Text button after highlighting all data to remove this and then you can manipulate your data
0
