Product List by Category and Subcategory

[lynettejackson]

Hello Alteryx, 

Issue: I'm not sure which Alteryx component I should use.  

I am new to Alterxy, I'm working on a workflow for publishing a product list's of laboratory equipment report that should be organized by manufacturer, equipment type and their subcategories.

Of each category there are 8,000 equipment records associated with each category that I want grouped without totals.

I attempted Cross-Tab, but it required aggregating and summarization or Concatenation, First or Last.

When I tried to use Reporting-Layout, I received an error message.

AGILENT

CHROMATOGRAPHY, LC AUTOSAMPLER

   INFINITY II HIGH SPEED PUMP

   LC AUTOSAMPLER

AURORA SCIENTIFIC

ANIMAL EQUIPMENT

   MUSCLE LEVERS

 I'd be grateful for any help I can get in improving the workflow.

Lynette Jackson

[mceleavey]

Hi @lynettejackson ,

can you please post some data (or mock data) showing what you're trying to do so we can help?

M.

[raychase]

Sounds like group by in the summarize tool could be your friend.

[lynettejackson]

Thank you for taking the time to get reviews. A copy of the Product list is added. Please see the pivot table for an example of how I expect the report output to appear.

Please let me know if you need any additional information.