Group By Cell in Table

Good morning all,

I am building out some reporting for my team and having issues getting the output to the correct format.

I have gotten everything else correct, except for displaying the Product IDs Grouped by Product Group, Product Name, and Contractor Names in the correct format. I'm not sure how to make Alteryx populate the Product IDs in separate rows grouped by these factors.

Attached is a test data file, and I've built out the report how it needs to look. I seriously appreciate any advice you can give me, as I need to complete this by the end of the week. As I mentioned, I'm able to get just about everything working correctly except the grouping.

Thank you so much!

Sample Data and Report.xlsx

Datasets

Output

Preparation

Accepted answers

fmvizcaino

Hey @ddaile17 ,

I could be mistaken, but unfortunately, as shown in your example, I don't think it is possible to group items. Maybe there is a workaround somewhere, but I assure you there isn't a native way of doing it.

Best,

Fernando Vizcaino

All comments

fmvizcaino

Hey @ddaile17 ,

Something similar to this?

Here is another example: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Multo-row-header/td-p/29185

Best,

Fernando Vizcaino

2021-11-29 Group By Cell in Table.yxmd

ddaile17

Thanks for the quick reply. This is how I currently have the report set up to generate when it outputs. However, my team is needing the report to show all product ID's by Product Group/Program Name grouped together. The attached snapshot shows the correct Output needed.

Output Sample.PNG

fmvizcaino

Hey @ddaile17 ,

Best,

Fernando Vizcaino

ddaile17

Gotcha, I appreciate you checking it out. I decided to alter the way the output looks by creating a horizontal table with the Product Group / Product Name and Contractor names, then putting the product id's and other information in a separate table under sorted the same way. I'm hoping to adjust how our data set is received so that I can tweak it a bit, but the formatting will work for now. I'd tested some similar situations that I'd found, but nothing really worked properly in a consistent format.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15872

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703