In Looker, table calculations enable you to create calculations that operate on the data table returned in the Explore page by a SQL query. This is great for calculating metrics like running totals. You can also create a running total across rows using table calcs, which you can read more about in the topic about running totals in the Looker Community.
To create a running total using table calculations, you can use the running_total()
function:
To create a running total of the column Inventory Items Count, include this table calculation in your SQL query:
running_total(${inventory_items.count})
This will produce something like: