Determining the top % of values in a column

[Jon_Taylor]

Hi,

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. 

Thanks,

Jon

[Emil_Kos · Accepted solution]

Hi @Jon_Taylor,

Please check my solution:

It is dynamic as you wanted:

What I did I have created a total value and after that, I have used it to calculate the percentage value. Running total allowed me to filter the data to show the relevant data. 

[Jon_Taylor]

@Emil_Kos  Thank you for the help and learning opportunity. This is great, and correct. It also shows me a great example of how to put the append tool and running total tool to use in a real example.