Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Percentile question in Cognos...

Status
Not open for further replies.

Maven4Champ

Technical User
Jun 16, 2004
154
Currently, I have a report that pulls from one of our databases and catalogs that basically tells us how many credit applications have been submitted by each region (north, south, east and west). the filter is setup to prompt for a timestamp for a start date and end date. and then to sort by regional office. Now, one of the query data in this report is what is called "Dealer Name" Though it's not a field that is actually shown in the report, it contributes. This is essentially how the report appears now:

Credit applications created by dealer

North Region
---------------
5142

South Region
---------------
3498

East Region
---------------
9354

West Region
---------------
6411


I want the report to also include the top 15 percentile and the bottom 15 percentile of dealerships who create these credit aps, list their dealer name (which is a field I have) and how many aps they specifically created.

so it should now appear like this:

North Region
----------------
5142
----------------
Top 15%
Dealer Company 1: 968
Dealer Company 2: 622
Dealer Company 3: 468

Bottom 15%
Dealer Company 25: 72
Dealer Comapny 19: 61
Dealer Company 11: 41
Dealer Company 73: 15



- Does that make any sense? Again, I can't seem to figure out how to really accomplish the percentage thing. Anyone have an idea. Do I just need edit the definion of the Dealer name in the query data, and if so which values and/or strings do I use in this situation to define the top 15% and the bottom 15%?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top