DataTable Filter

Hi, i am trying to filter some data of a group of student’s results from Microsoft excel, and i need to extract out the bottom 10% of the cohort, how do i indicate that i want to only extract the bottom 10% of the cohort such that even the sequence are different, when i automate it, i will still draw the bottom 10%?

In your excel what is the type for 10%. is it percentage or general or text etc?

in read range you have to check the “preserve format” option in properties. Please find the attached flow. (17.1 KB)

Percentage, so there will be 30 different scores of 30 different students, i want to extract the bottom 10% score of these 30 students