Calculate the percentage split across two categories

[SnapperFlower]

Hi Alteryx Community,
I’m trying to calculate the percentage split of Apples and Bananas across two categories (Boxes and Trays) in Alteryx. Here’s what I want to achieve in excel (also attached)

[jrlindem]

This is certainly possible in Alteryx.  I've shown below and attached a workflow that shows you how to re-arrange the data, compute the Grand Total and Percentages, and then arrange it back to match your output example.  May not be entirely useful in that final format, but this gives you the basis for working the data around.

Hope this helps!  -Jay

[SnapperFlower]

Thank you for this, much appreciated. Could you explain the logic of this tool?

[jrlindem · Accepted solution]

All i'm doing there is establishing the order in which I wanted the data rows to appear.  This is "brute forcing" the order so that your fruit values showed up, and then the Grand Total, and then the percentages.  Nothing more than a creative way to make the data sort in the order I wanted it.  The values of 50 and 99 are arbitrary.

[SnapperFlower]

 Thank you!