Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Top 10 and Total in a single Report

Hi ,
I have requirement of a report which should include the following
1) top 10 customers and their profit.
2) Below it total Customers(100) profit
3) Below it Total customers - Top 5 cutomers Profit (other customers)
4) Todays profit - ydays profit
5) Todays profit - previous 7th day profit.(weekly difference)
I was not able to put, top 10 and total customers into one report. Am i missing something? I am doing a report for Top 10 and another for 2,4& 5 seperatly.Not sure of calculating Other customers.Please help
Answers
-
Hello,
For your report 1, 3:
1. What i recommend is to use a different object analysis by each report that you have because you have to use different filter by each report, to get a "clean" solution.
Filter:
Report1 : Rank(Measure Profit) < 10
Report2 : Rank(Measure Profit) < 5
2. In other hand, that you want to show TOP RANK CUSTOMER 10 and OTHERS Rows check this link : OBIEE TopN versus the rest : Total Business Intelligence
and do the same for 5 RANK CUSTOMER, create a two different pivot table views to show both of the RANK 10 / 5.
For your report 4,5 :
1. Use a Times Series Function report 4 (its no clear to me) but you say that you have YEAR TO DATE Report? Use TO_DATE Function,
Compare weekly difference AGO Function.
Kind Regards,
0 -
Hi Cesar,
Thank you.
Right now i implemented 1 to 3 in the same report and 4 and 5 in a separate report. I still need to work on the report.
Regards,
Kalpana
0