Filter Table Bottom 40%

Output: FilterTableBottom40Percent.xlsx

public void Run()
{
    var workbook = new Workbook();
    var worksheet = workbook.Worksheets[0];
    worksheet["A1"].Value = "Name";
    worksheet["B1"].Value = "Number";

    worksheet.GetRange("A2:A11").SetValue(new[] { "Item1", "Item2", "Item3", "Item4", "Item5", "Item6", "Item7", "Item8", "Item9", "Item10" });
    worksheet.GetRange("B2:B11").SetValue(new[] { 10,20,30,40,50,60,70,80,90,100 });

    var table = worksheet.Tables.Add("A1:B11", true);
    table.Id = 2;
    table.Name = "Table1";
    table.DisplayName = "Table1";
    table.HeaderRowCellStyle = "Heading_3";
    table.TotalsRowVisible = false;

    table.Filter();

    var filter1 = new DRIT.Spreadsheet.Filter();
    filter1.Top10 = new Top10Filter();
    filter1.Top10.FilterValue = 3;
    filter1.Top10.Value = 40;
    filter1.Top10.Percent = true;
    filter1.Top10.Top = false;
    table.AutoFilter.Columns.Add(1, filter1);
    table.AutoFilter.Apply();
            
    workbook.SaveAs("FilterTableBottom40Percent.xlsx");
}