Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Oracle BI Analysis not in TOP function union IS IN TOP 10
Hi!
I have a requirement to see top 10 Balances Cost Center wise with sum of other remaining records AS "Others". To fetch top 10 record i have used filter IS IN TOP 10 function. now i want to add Others as a sum of all remaining records. Scenario can be seen in the attached image.
Regards,
Answers
-
I'd use a union query, with the second query filtered on NOT IN TOP 10, and place a value of 'Others' in the cost center column (thereby "collapsing" all of the non-top 10 Cost Centers into a single record). Depending on your data, the Transaction Amt column may have to be sum(Transaction Amt). It may be that you want to add a label column such as 'Top 10' for the first query, and 'Others' for the second query. That way, you can subtotal for the top 10 and the others.
0 -
Hi ,
You can use selection steps to achieve this requirement. It is breeze to achieve this complex requirement.
0 -
Hi ,
Please mark as answered , if this has solved your problem
0
