% of each line item with respect to the grand total

[Kamran1991]

Hi all,

In the attached excel file, I have a dummy data from Jan to Dec with account nos, Items' name and their mapping(category).  I wanted to calculate the mapping wise, then grand total for every month, which I have successfully done through attached workflow. Now, I want to calculate the weightage of every line item for every month with respect to the grand total of that month.

Once you go through the attached files for source data and required output along with the Alteryx workflow, you can easily understand the query.

Your suggestions will be highly appreciated.

Thanks!

Kamran

[atcodedog05]

Hi @Kamran1991 

Fun challenge. You can make use of crosstab column percentage aggregation feature. Please refer the screenshot.

Output:

Hope this helps : )