-- See the result how it calculated
DECLARE @tab tABLE(ITEM VARCHAR(10), VALUE DEC(10,4), STATE VARCHAR(10))
INSERT INTO @tab
SELECT 'Item A', 69622.1990, 'RED' union all
SELECT 'Item B', 47987.9352, 'YELLOW' union all
SELECT 'Item C', 11237.4420, 'RED' union all
SELECT 'Item D', 12063.1895, 'RED' union all
SELECT 'Item E', 42324.9775, 'YELLOW' union all
SELECT 'Item F', 24539.4310, 'RED'
/*
PERC OF MAX PERC OF SUM
69,622.1990 100.00% 33.51%
47,987.9352 68.93% 23.10%
42,324.9775 60.79% 20.37%
24,539.4310 35.25% 11.81%
12,063.1895 17.33% 5.81%
11,237.4420 16.14% 5.41%

SUM 207,775.17 
MAX 69,622.20 */
SELECT 
	VALUE
	,VALUE*100/ Sums AS PERC_OF_SUM
	,VALUE*100/ Maxx AS PERC_OF_MAX
FROM ( SELECT SUM(Value) OVER() Sums, MAX(VALUE) OVER() Maxx, * 
		FROM @tab 
	 )T
ORDER BY VALUE DESC