Is it possible to define cumulative measures in a table? Or at least have a pivot table show cumulative values
The spreadsheet mockup shown below illustrates what I am seeking
I want a ‘cumulative’ measure that can report all the values up to and including the time period in the column, including periods not in the report scope. i.e. before Jan
The ‘running total’ measure type is not the solution here, as it only seems to work for columns in the report display. Hence, if I changed the pivot table to show just Feb to April then with running total the ‘Acme’ row would not appear
In an OLAP tool this type of problem is pretty straightforward. I’d create a ‘Value’ dimension and have two members: ‘current month’ and ‘cumulative’, where the later would perform a sum on the related time dimension. But that type of cross-view calculation is a big hole for Looker.
Any suggestions?