I have the following data in alteryx.
| Name | Category | % | Output |
| A | XX | 25% | YY |
| A | YY | 75% | YY |
| B | XX | 40% | XX |
| B | YY | 20% | XX |
| B | ZZ | 15% | XX |
| B | QQ | 25% | XX |
| C | ZZ | 20% | General |
| C | XX | 40% | General |
| C | YY | 40% | General |
| D | YY | 100% | |
| E | QQ | 50% | |
| E | ZZ | 50% | |
I want the output to be the category column based on maximum value of % in a name. For example - For B, 40% is maximum, hence output is XX which corresponds to 40%
However, if the maximum % is same of two categories, I want it to be tagged as "General". For example: in C, the max % is 40% of XX and YY, hence tagging is "General"
Please help, thanks!
