> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# CumulativeMax

> Use the Sigma CumulativeMax function to calculate the maximum of a column up to and including the current row value.

The **CumulativeMax** function calculates the maximum of a column up to and including the current row value.

## Syntax

```
CumulativeMax([Column])
```

Function Arguments:

* **\[Column]** (required) - The column of numbers to evaluate the cumulative max.

Cumulative functions depend on the order of the given column. If you change the sorting you will change the result.

## Example

```
CumulativeMax([Monthly Revenue])
```

A table contains the monthly revenue for a store. The CumulativeMax function can be used to find the maximum monthly revenue up to and including the current month.

![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/c4608555c4b7590965c67a798e5315289b249ffeeafc3f71f90e7248e7eafb6d/assets/docs-images/a74bbce-3.png)

## Related resources

* [CumulativeMin](/docs/cumulativemin)
* [Max](/docs/max)
* [MovingMax](/docs/movingmax)