Need assistance in creating pivot table

[vrajgopal]

When I create a pivot in excel, I can put the “Product/Service” (a column in the raw data) as row in Pivot instead of a column and get the desired results. The same almost works in Alteryx (I am not sure if i am using the table option correctly or if i am missing a step).

The challenge I am facing is that it creates 2 rows called product and service even though there is no value for one of them.

I have attached the workflow which I have created with raw data.

Vishwanath

[Jean-Balteryx · Accepted solution]

Hi @vrajgopal ,

I'm not sure to have fully understand what you want but I modified your workflow to match your need. Tell me if that's what you want.

Cheers,

Jean-Baptiste

[vrajgopal]

Thank you.

Is it possible to have only one amount column. 

[Jean-Balteryx · Accepted solution]

@vrajgopal ,

I feel like a Summarize would better suits your need if you want the total amount not regarding Product/Service.

I attached the modified workflow.

Cheers,

Jean-Baptiste