USEFUL: Add running totals to enhance web reporting
In today’s blog post I want to tell you how to get more from Flexmonster pivot with the help of running totals.
To begin with, I’ll tell you what is it - running totals. This is one of the aggregations available for CSV and JSON data sources. It shows the total sum of some value that changes as you add or subtract some values in the next row. To demonstrate how this aggregation works, I suggest you have a look at the following table:
| Quarter | Total Sum of Revenue | Running Totals of Revenue |
|---|---|---|
| Q1 | $3,600 | $3,600 |
| Q2 | $4,800 | $8,400 |
| Q3 | $5,100 | $13,500 |
| Q4 | $6,400 | $19,900 |
The first column contains quarters, the second column - total revenue for each position. In the third column, we have running totals. In case of Q1, running total equals total sum of revenue for Q1, which is $3,600. For Q2, we add total sum of revenue for Q2 to the previous value ($4,800 + $3,600 = $8,400).
This simple example explains the gist of running totals. Such aggregation is a convenient alternative to familiar sum.
- via UI: press the sigma icon next to the value name in Field List and choose Running totals aggregation
- via report: specify
"aggregation": "runningtotals"for the necessary measure in the slice
In Flexmonster pivot you can set running totals in two ways:
I hope you will find running totals useful for your reporting!
You can also check out all the aggregation options our pivot grid supports.