DataTable Filter


#1

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%?


#2

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


#3

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


#4

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