PLEASE NOTE: Since we update Flexmonster Pivot with new features biweekly, the information might become outdated. Please check our latest news.
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|
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.
"aggregation": "runningtotals"for the necessary measure in the slice
I hope you will find running totals useful for your reporting!