How to create a customized query for table?

[mahesh27]

 table 1:

_time	allocation	website	quantity	failed	impacted_allocations
2022-10-12 09:00	CMD	www.asd.com	100	20	5
2022-10-13 10:00	CMD	www.asco.com	200	30	10
2022-10-25 15:00	KMD	www.hyg.com	300	40	12
2022-11-01 18:00	KMD	www.sts.com	400	50	18

table2:

Presently I have table 1 but the requirement is  last column called "impacted_allocations" should get added up and display the added number
for example: For allocation we have 2 rows as "CMD" so for  CMD -impacted_allocation values should get added up(5+10=15) and show as 15 in the table.
the same goes with the KMD(12+18=30) 30 should display in my table as shown below.

_time	allocation	website	quantity	failed	impacted_allocations
2022-10-12 09:00	CMD	www.asd.com	100	20	15
2022-10-13 10:00	CMD	www.asco.com	200	30
2022-10-25 15:00	KMD	www.hyg.com	300	40	30
2022-11-01 18:00	KMD	www.sts.com	400	50

[ITWhisperer]

| eventstats sum(impacted_allocations) as total_impacted_allocations by allocation

[vishwa]

@ITWhisperer , thank you for the query, it helped.