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% |
Solved! Go to Solution.
you got a nice prep, blend and calculating ratios challenge.
Here is my quick solution to it:
You can tweak it to your liking.
Please mark this as the solution if it answers your question, it will help others to find solutions quicker.
Kind Regards,
Kilian
Solutions Engineer - Alteryx
Hi @KilianL
Thanks for the solution. It worked....
Regards
Akshay