Adjusting the proportion of value of a region to another fields

[syed-mohiuddin245]

Hello Alteryx Experts,

I am working on a flow where I have a logic to be applied. The proportion of total value of Electrical Industry for America region should be adjusted in 3 fields as per below criteria. The logic is only values of AMERICAS for those specific fields to be adjusted. Rest all values should be same . For example, values of EMEA, APAC regions should be same for those industry names.

Can any of the experts guide me how can I do it. I can do it manually in Excel by taking pivot table and applying the percentage formula manually.

This tried 3 days in different methodologies, I am still unable to get proper results. Please experts guide me with some method where I can create this flow.

I tried to take sum of the value of Electrical for AMER region and connected it in flow. Still its creating discrepancy in my values. I tried to do it by formula field and hardcode the logic with the help of IF - ELSE IF . Its also not helping me. Values are being added up.

Can someone say what I am missing here and what can I do.

I am attaching the dataset for your reference if someone like to help me in creating flow. (Use "MASTER DATA" sheet)

Proportion of Electrical Industry to be added
Region	Row Labels	Sum of FY21	Sum of FY22
AMER	Aerospace	FY21 + 24Percent	FY22 + 24Percent
AMER	Communication	FY21 + 15Percent	FY22 + 15Percent
AMER	Services	FY21 + 8Percent	FY22 + 8Percent

The trick here is I need to add the %proportion of Electrical industry to those 3 industries.

If I do it manually, it will be like below.

Sum of Electrical for AMER region is below.

Region	Industry	Sum of FY21	Sum of FY22
AMER	Electrical	40619	42638

Region	Industry	Sum of FY21	Result
AMER	Aerospace	(=44753*24% of 40619(total of Electrical AMER region)	53689.18
AMER	Communication	(=45578*15% of 40619(total of Electrical AMER region)	51670.85
AMER	Services	(=40671*8% of 40619(total of Electrical AMER region)	43920.52

And the above result of AMER region is adjusted in Global by replacing AMER values with above values.

I am not sure, how this is possible. One more major concern is, the values should be divided line level. Above example is done after summarizing, If I follow summarize values, it will double / triple in line level.

I will replace sum values of AMER from below grand total to above sum values.

Region	Sum of FY21	Sum of FY22
AMER	131002	124928
APAC	186170	194837
EMEA	187858	186140
Grand Total	505030	505905

Please help me with suggestions on this .

Thank you in advance for helping me out.

[cmcclellan]

I'm pretty sure this is what you want, but I'm assuming it's always the same increase in both years.

[syed-mohiuddin245]

Thank you so much for your help.

The trick here is I need to add the %proportion of Electrical industry to those 3 industries.

If I do it manually, it will be like below.

Sum of Electrical for AMER region is below.

Region	Industry	Sum of FY21	Sum of FY22
AMER	Electrical	40619	42638

Region	Industry	Sum of FY21	Result
AMER	Aerospace	(=44753*24% of 40619(total of Electrical AMER region)	53689.18
AMER	Communication	(=45578*15% of 40619(total of Electrical AMER region)	51670.85
AMER	Services	(=40671*8% of 40619(total of Electrical AMER region)	43920.52

And the above result of AMER region is adjusted in Global by replacing AMER values with above values.

I am not sure, how this is possible. One more major concern is, the values should be divided line level. Above example is done after summarizing, If I follow summarize values, it will double / triple in line level.

Please help me with suggestions on this .