Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to count?

Received Response
13
Views
4
Comments
3280272
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?

customer.png

Answers