---
title: Query cumulative sum
description: Use the cumulativeSum() function to calculate a running total of values.
url: https://docs.influxdata.com/influxdb/cloud/query-data/flux/cumulativesum/
estimated_tokens: 904
product: InfluxDB Cloud (TSM)
version: cloud
---

# Query cumulative sum

Use the [`cumulativeSum()` function](/flux/v0/stdlib/universe/cumulativesum/) to calculate a running total of values. `cumulativeSum` sums the values of subsequent records and returns each row updated with the summed total.

**Given the following input table:**

| _time | _value |
| --- | --- |
| 0001 | 1 |
| 0002 | 2 |
| 0003 | 1 |
| 0004 | 3 |

**`cumulativeSum()` returns:**

| _time | _value |
| --- | --- |
| 0001 | 1 |
| 0002 | 3 |
| 0003 | 4 |
| 0004 | 7 |

The examples below use the [example data variable](/influxdb/cloud/query-data/flux/#example-data-variable).

##### Calculate the running total of values

```js
data
    |> cumulativeSum()
```

## Use cumulativeSum() with aggregateWindow()

[`aggregateWindow()`](/flux/v0/stdlib/universe/aggregatewindow/) segments data into windows of time, aggregates data in each window into a single point, then removes the time-based segmentation. It is primarily used to [downsample data](/influxdb/cloud/process-data/common-tasks/downsample-data/).

`aggregateWindow()` expects an aggregate function that returns a single row for each time window. To use `cumulativeSum()` with `aggregateWindow`, use `sum` in `aggregateWindow()`, then calculate the running total of the aggregate values with `cumulativeSum()`.

```js
data
    |> aggregateWindow(every: 5m, fn: sum)
    |> cumulativeSum()
```

#### Related

-   [cumulativeSum() function](/flux/v0/stdlib/universe/cumulativesum/)

[query](/influxdb/cloud/tags/query/) [cumulative sum](/influxdb/cloud/tags/cumulative-sum/)