This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am seeking a solution to find the Top 80% or more of a column to that columns total.I tried using the sample tool using"first N% " but I believe the tool is pulling the rows at that %. So like if I have 10 rows and pull 50% ill get the first 5 rows. is this correct? what I want to do is look through the column and pull the rows where the values sum to 80%+.
Here I know the first 3 lines make up 98% of the total amount. I want this to be automatic rather than have to calculate it myself and update the sample tool from "first 3 rows" to how ever many rows it changes to in the next run.