Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 20 Oracle Analytics Lounge
- 246 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 91 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to count?
3280272
Rank 3 - Community Apprentice
Hi.
Suppose we have a certain set of customers with sales values for each of them.
I need to get first and last 25% of customers and average values for this 25%
The results should show us something like 25% get the average sale more then a 40 000 (example number), 25% get the average sale less then a 1000 (example number).
Some idea how in Obiee 12c?
0
Answers
-
-
You might also consider using the filter function; -
0 -
The solution was to use the NTILE function.
She divided the results into selected numbers of groups.
0 -
One of the answers. Not "the answer".
0