80 20 rule

[oliver_penney]

hi all

i have a table of things we sell and i wanted to apply an 80/20 filter to get the 20% we sell producing the 80% of revenue

how do i go about creating the query?

thanx in advance

oliver

 

[Parra]

Lets see if I can help, but before I type everything down, do you have experience using Access and creating queries?

My idea would work from creating a query of a query.

Parra

 

[oliver_penney]

yeah, i'm pretty good in access



just stumbling on this one

 

[Parra]

OK lets see if I can help but I am hung over.

Query 1 will have 2 columns, the product and the summation of its price. that will give you all the products and the total revenue each generated.

Query 2 will have 1 column which is the summation of column 2 of query 1, that will only give you one cell.

Query 3, will be query 1 divided by the result of query 2, that should give you the percentage each product contributed to the total revenue.

I don't know if you can do this in query 3 or create another query but then do a Max function of Top function to get the top 20% products.

Did this help or am I still drunk....

Parra

 

[oliver_penney]

aha, that would work

i've fudged it though and put a filter for greater than the revenue amount to get into the upper 20%

nice to know what the solution would be to a more dynamic data set

thanx

)

ol