Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

USEFUL: Add running totals to enhance web reporting

PLEASE NOTE: As soon as we update the Component with new features every new week the information might be 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
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.

    In Flexmonster pivot you can set running totals in two ways:
  • 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

I hope you will find running totals useful for your reporting!