I have a table that shows inventory item purchases.

If I have an example where 100 items were purchased during a time period and the sum of these purchases equals $100,000

What I am looking for is to show the items purchased that represent the top 70% of the total purchased value.

So in this case, I am trying to list the items where the sum of the individual purchase values adds up to $70,000.

I am assuming that I want to work with a query table and with sql I understand that I would use a select statement like SELECT TOP 70 PERCENT ......

But I am working in MySQL so this function is not available.

Any assistance would be appreciated.

Regards,

Pete