how to add add a new column at the front of the table?

[ASHccccc]

as the pic  above, Alteryx has summarized the received vol for me, but when I used the CrossTab tool to make the table horizon, it became:

I cannot indicate it's the Received Vol per month, anybody can help that how to add the front column to indicate that first row is Month, and 2nd row is the vol?

[IraWatt]

Hey @ASHccccc,

Is this the table your looking for:

It has each month as a row. The group by data shown above indicates what the rows will be in the cross tab.

Any questions or issues please ask :)
HTH!
Ira

[Kurohits · Accepted solution]

I hope this will help you what you are looking for. I have attached the workflow also for your reference. Kindly accept this as solution if this approach worked for you. 

[binuacs · Accepted solution]

@ASHccccc Another way of doing this

[ASHccccc]

Many thank @binuacs

sorry that one more question, I tried with your solutions, but  at CrossTab tool I found the I cannot locate the aggregation method correctly, which shown:

so I tried to check back the Transpose tool, I found that the output Value at this section are different:

here is mine:

and yours:

is this the matter?

[ddiesel]

Hi @ASHccccc!

In @binuacs solution, the numbers are stored as numeric data type (as indicated by the 123). It appears that the values in your workflow are stored as strings (as indicated by ABC)

For string fields, you can only perform text based aggregations like concatenate, first, or last. To do any math, such as SUM, Average, etc., the data type must be changed to numeric.

You can accomplish this with the Select tool to change the data type before the Cross Tab tool. Tip: Make sure all the values in your real data are numbers first!

Check out section 4 of the help documentation for more information:

https://help.alteryx.com/2018.2/CrossTab.htm

Hope this helps!

Thanks,
Deb