Calculation using sum of rows in straight table

[#1]

Hi Experts,

i have the following straight table

Area	Vehicle	Deliveries	Orders
Total		2337	1285
Aberdeen	CoR12	30	29
Aberdeen	CoR13	48	15
Aberdeen	CoR14	115	94
Aberdeen	CoR15	538	418
Aberdeen	CoR16	136	128
Aberdeen	CoR17	3	0
Aberdeen	CoR18	88	0
Aberdeen	CoR19	140	93
Aberdeen	CoR20	41	27
Aberdeen	CoR21	1099	432
Aberdeen	CoR22	10	1
Aberdeen	CoR23	70	37
Aberdeen	CoR24	19	11

For each area, i have Deliveries and orders rexpectively. i have to calculate another column which gives % delivered

the formula for that is [Deliveries value of each vehicle] divided by the total value 2337. this total is not the expression total. it is the sum of all rows.

For eg. my first column calculation is 30/2337 = 1.28%

calculation for deliveries is sum(order_delivered)

required output:

Area	Vehicle	Deliveries	Orders	% Delivered
Total		2337	1285
Aberdeen	CoR12	30	29	0.01
Aberdeen	CoR13	48	15	1.60
Aberdeen	CoR14	115	94	2.40
Aberdeen	CoR15	538	418	4.68
Aberdeen	CoR16	136	128	0.25
Aberdeen	CoR17	3	0	0.02
Aberdeen	CoR18	88	0	29.33
Aberdeen	CoR19	140	93	1.59
Aberdeen	CoR20	41	27	0.29
Aberdeen	CoR21	1099	432	26.80
Aberdeen	CoR22	10	1	0.01
Aberdeen	CoR23	70	37	7.00
Aberdeen	CoR24	19	11	0.27

Is this possible?

if so, can someone please help me with expression?

i tried using Total & All function, but it is not giving the sum of rows value. it is giving expression total of that column.

Please help

[#2 · Accepted solution]

calculation is

sum(TOTAL Aggr(sum(order_delivered),Area, Vehicle))

[Anil_Babu_Samineni]

Try like this for % Delivered

sum(order_delivered)/sum(total orders)

And then give relative