Categories
- All Categories
- 71 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Cells are not merged for formulas
Dear All,
I have developed a custom OTBI report to retrieve data related to the payable module; however, invoice number and supplier number are merged when the data is equal, but the formulas associated with the invoice are not merged when the data is the same and are duplicated in many cells.
The suppress option is not working fine for formulas:
Is there a way to achieve that for formulas? Could you please advise?
Regards,
George
Answers
-
Hi George,
Please review the below CCC discussion on a similar issue.
Thanks.
0 -
Hi George,
This is expected behavior and alternative is pivot view usage.
Please review the below CCC discussion on a similar issue.
Regards,
0 -
Hello and good day!
Dearest George,
I think you can not suppress if it is a calculated value, For my sample OTBI below what I did is use a sub total. Hope this will help your requirement.
Thanks and best regards.
Regie
0