Query for running total in SQL Server

Another way of getting totals, whether it be by group or set is to use the CUBE and ROLLUP predicates.

By group (each grouping of FIELD_DESCRIPTION will have a total sum):

SELECT
	FIELD_DESCRIPTION
	, SUM(FIELD_VALUE)
FROM
	tbl_Data
GROUP BY
	FIELD_DESCRIPTION
WITH CUBE

Or:

By Cube (the final set of FIELD_VALUE will have a total sum):

SELECT
	FIELD_DESCRIPTION
	, SUM(FIELD_VALUE)
FROM
	tbl_Data
GROUP BY
	FIELD_DESCRIPTION
WITH ROLLUP

Reference: Summarizing Data Using ROLLUP[^].