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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Making a cumulative rank ?

Status
Not open for further replies.

barneyc2001

Technical User
Jan 17, 2011
1
0
0
GB
Im trying to come up with a way to bring back at least 80% of the data relating to a subset of products im running a query on.

As an example below is what ive been able to do, however what i want to do is include all of product 4 to ensure that i have at least 80% of the products.

product cum % include
1 25% Y
2 45% Y
3 65% Y
4 90% N
5 100% N

Can anyone help me with this?

Cheers

Barney
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top