please let me know how to calculate "Output Column (PO%)" as below :
| Commodity | MTO | PO Qty | Output Column
(PO %) | |
| Grand Total | | 252007.83 | 100% | |
| HA-Pipes | 1 | 61415.05 | 60% | PO qty /subtotal |
| HA-Pipes | 2 | 32450.24 | 32% | |
| HA-Pipes | 3 | 6647 | 7% | |
| HA-Pipes | 4 | 1263.54 | 1% | |
| HA-Pipes Sub-Total | | 101775.83 | 40% | subtotal / Gran Total |
| HB-Valves | 1 | 4077 | 63% | |
| HB-Valves | 2 | 2210 | 34% | |
| HB-Valves | 3 | 204 | 3% | |
| HB-Valves Sub-Total | | 6491 | 3% | |
| HC-Flanges | 1 | 4016 | 35% | |
| HC-Flanges | 2 | 5284 | 46% | |
| HC-Flanges | 3 | 1748 | 15% | |
| HC-Flanges | 4 | 370 | 3% | |
| HC-Flanges Sub-Total | | 11418 | 5% | |
| HD-Fittings | 1 | 12816 | 37% | |
| HD-Fittings | 2 | 12810 | 37% | |
| HD-Fittings | 3 | 8060 | 24% | |
| HD-Fittings | 4 | 539 | 2% | |
| HD-Fittings Sub-Total | | 34225 | 14% | |
| HE-Fastners | 1 | 10981 | 16% | |
| HE-Fastners | 2 | 37455 | 56% | |
| HE-Fastners | 3 | 18788 | 28% | |
| HE-Fastners Sub-Total | | 67224 | 27% | |
| HF-Gaskets | 1 | 2294 | 10% | |
| HF-Gaskets | 2 | 13240 | 56% | |
| HF-Gaskets | 3 | 8286 | 35% | |
| HF-Gaskets Sub-Total | | 23820 | 9% | |
| HG-Specialities | | 3329 | 79% | |
| HG-Specialities | 1 | 508 | 12% | |
| HG-Specialities | 2 | 363 | 9% | |
| HG-Specialities Sub-Total | | 4200 | 2% | |
| HH-Supports | 1 | 1748 | 63% | |
| HH-Supports | 2 | 1024 | 37% | |
| HH-Supports Sub-Total | | 2772 | 1% | |
