Running Total field calculations in Report Builder
Report Builder supports Running Total Field Calculations. You will find this feature helpful in reports that involve tallying totals within or across specific groupings.
To explain further, let's take a look at our example report.
If you right-click on the field, you will see you have the option to set as a running total field. This will give you the option to calculate the data in the selected field:
In our example, we chose to take the sum of the running total field. This is how it will show when you preview the report:
.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9kemY4dnF2MjRlcWhnLmNsb3VkZnJvbnQubmV0L3VzZXJmaWxlcy8xMjgyLzE5MDEvY2tmaW5kZXIvaW1hZ2VzL2ltYWdlKDE4MjQpLnBuZyIsIkNvbmRpdGlvbiI6eyJEYXRlTGVzc1RoYW4iOnsiQVdTOkVwb2NoVGltZSI6MTczNTU3OTU2NH19fV19&Signature=QRhiRQTHsbss05~gojX4jd0VDC96IjoNZqR9vrevd~v4ncdCc9mxciyDUAlNf2ZdmsXceMClrDBgXP3tCwsUSlzDpZthpeO4SdVhWdIWYZmd9ymyUmY3~M1rcFjTvlRaS4htK2JOMC6QqCeiymFefVOgzCTR2IcavT5OguzcYNlVHJZmyyUFse2JV7zvgMkBsgAalu-nDDI117rJZ1yyzEs2AQf4DN0j1AhDaHXVGZvBHx9oCN6RQyPcxKOX5ivrb19u35gzBEcmi-eXiUS3naWn4kfPQcauqC45AtyRhgm6OOtxdSGnvb3QvufPlGTPDwN1IFfojsZ7xxTA-Kib2A__&Key-Pair-Id=K2TK3EG287XSFC)