cumulative sum

Hi all, I am trying to calculate the percentiles in a frequency table, but I'm having trouble creating the cum sum with multiple criteria - the idea is to replicate the values in column D State Color Count Cum. sum for "blue" per state Alabama Blue 2 2 Alabama Yellow 4 Alabama Blue...

Hello, I am trying to create a column in PowerBI that takes the cumulative sum of a table column of numbers, *but*, if in any row the value of that sum is exceeded by a number in a secondary column, the cumulation is replaced with that secondary number. The cumulative sum would then carry on...

I have a small piece of code which checks if a cell is >0. The answer is either a 0 or 1, so if the cell is >0 it is a 1, otherwise it is a 0. What I'd like to be able to do is for that column to tally as it goes; so keep a running total. I have read many threads on this, but nothing which...

Hi I've got a set of data that each week I need to run a report to see what the cumulative total should be Is there a way I can do this in a formula? A B C D E 1 17/04 2 17/02 17/03 17/04 17/05 3 15 10 20 10 I would like to perform a total based on the value...

Hi, I have an automatic (tipping bucket) rain gauge that records the time of tip to the nearest second. These are random and do not follow a distinct pattern. I would like to aggregate the time of tip data to show a 15min cumulative total for that 15min period. The data is laid out as simple...

Hi all, Below is a copy of the data. I need to have a cumulative sum of column b, that resets the count to zero if i encounter a reset condition. The problem is I do not know when the reset(s) will occur( It is not a fixed location), so the challenge is catching the moving target. Also the...

Hello everyone! I hope that you can help me with a particular problem that I am having. Namely, I am working on an Excel sheet where I am trying to make a formula that creates a cumulative sum after a number reachest a maximum. For example, I have one component whose maximum Operating hours is...

Hi, I am trying to display our season totals on one graph. We call this "The Worm" it shows the cumulative total rising for each season. At the moment I get each year separated (pic 1) however I want them all on the same x-axis over 1 year (pic 2). Ideally for this coming year it will have...

Hi. I'm trying to create a bar and line graph displaying cumulative sums over time. Here is an example. Imagine you have three shops with respective sales over 12 months. Jan Feb Mar Apr etc Shop 1: 23 25 20 18 Shop 2: 14 12 12 15 Shop...

Hi All, Sorry if this has been asked before, but I've had a search and can't find an answer. I'm using Excel 2010 and Windows 7 I'm trying to find a YTD total in a pivot table. I've been able to use the running total function to get a YTD figure from my data. However, this table currently...

Hi all, I am trying to do the following: - I have a list of items (say cars), one on each line, and attached there is the name of the owner and the value of the car - I need to pick up the first n most valuable cars for each owner up to a value of x - every car that makes me exceed the total...