% calculation in single column

[Akshay_Patole]

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%

[KilianL · Accepted solution]

Hi @Akshay_Patole 

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

[Akshay_Patole]

Hi @KilianL 

Thanks for the solution. It worked....

Regards

Akshay