Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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