Cumulative Count by Category, Sorted by Frequency
Hello. I have data that needs to be arranged by frequency (how many claims have occured) per location. The result is a bar graph with the locations with the most claims appearing first: Nice! First part is done. I then need to create a line that cumulatively sums up the total number of claims for each location, then displays it as a percentage of the total number of claims (for the filtered timeframe). Hypothetically it would look something like thisq (this screenshot comes from Excel): However I cannot seem to get the line to cooperate. My last attempt ended up looking like this: Any feedback on how to make this line function like the one above would be much appreciated. Thank you!
