In segments, Sprinkle now allows running total i.e. summation of numbers which is updated every time a new number is added to the sequence. Select any segment and click on “settings”
On selecting “settings”, a pop up window will appear named “Table Calculations”
Pivots and Transposes can be applied when necessary. In the aggregate column, “Running total” should be selected. Post this, the column on which running total is to be applied should be selected in “select column for aggregation”
Format of show total columns is where the user is required to select between value, percent or both value and percent. Here, we have selected Value. On Clicking “Ok” the settings are applied.
A new column is added and named as “Running total Sum_OrderLineAmount”
On selecting “Percent” in format to show total columns, the newly added column will be displayed on the basis of percentage. On selecting Value(Percent) both value and percentage will be displayed.