Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can use the aggr() function based on the dimensions.