> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/docs/cumulativemax/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

```sigma
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

```sigma
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.

![](/_fern-img/c4608555c4b7590965c67a798e5315289b249ffeeafc3f71f90e7248e7eafb6d.webp)

## Related resources

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

> Official documentation and guidance for using Sigma to build AI apps, dashboards, and agents on governed warehouse data.