Randomly selecting a percentage of cells based on multiple criteria

[idealady]

Hello -

I have a report that has multiple products(in one column 'products') with unique rows of sale data (980 rows (variable). Each product has a status column displaying either "sold" or "inventory".

The goal: based on product and status - randomly select 10% of rows for each product/status grouping and flag the selected row. See data below (reduced for simplicity): Select 10% is the column that identifies randomly selected cells.

Thanks for any assistance you can give.

[TABLE="width: 279"]
<TBODY>[TR]
[TD]Product</SPAN>[/TD]
[TD]Status</SPAN>[/TD]
[TD]Select 10%</SPAN>[/TD]
[/TR]
[TR]
[TD]Widgit 1</SPAN>[/TD]
[TD]Sold</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Washer</SPAN>[/TD]
[TD]Inventory</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Sprocket</SPAN>[/TD]
[TD]Sold</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Widgit 1</SPAN>[/TD]
[TD]Inventory</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Washer</SPAN>[/TD]
[TD]Inventory</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Sprocket</SPAN>[/TD]
[TD]Sold</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Washer</SPAN>[/TD]
[TD]Sold</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Widgit 1</SPAN>[/TD]
[TD]Sold</SPAN>[/TD]
[TD] [/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>[/TABLE]