Using sum value from straight table

[hibhardwaj]

I have the following straight table in the front end: (Table's name is TabA)

Origin City Name	Code	PO Number	Value	Percentage	Sub parts
CHENNAI	100160	101741	6.73	1.43%	0.64
CHENNAI	100160	101344	8.54	1.81%	0.81
CHENNAI	100160	101361	4.69	1.00%	0.45
CHENNAI	100160	101787	44.93	4.82%	2.17
CHENNAI	100160	101478	5.02	1.06%	0.48
CHENNAI	100160	101789	7.36	1.56%	0.70
CHENNAI	100160	101970	2.24	0.48%	0.21
CHENNAI	100160	101942	10.35	2.20%	0.99
CHENNAI	100160	101853	44.94	8.94%	4.02
CHENNAI	100160	101315	44.94	8.94%	4.02
CHENNAI	100160	101603	1.38	2.08%	0.94
CHENNAI	100160	101730	6.59	9.94%	4.47
CHENNAI	100160	101539	31.94	48.19%	21.65
CHENNAI	100160	101266	0.86	1.27%	0.57
CHENNAI	100160	101510	2.57	3.87%	1.74
CHENNAI	100160	101971	1.59	2.40%	1.08
Sum	Sum	Sum	224.67	100.00%	44.93

Now, I want to create a dial using the sum of sub parts. Is there a way to reference the sum?

Any help will be much appreciated.

Thanks,

~H

[#2]

You can use the aggr() function based on the dimensions.