Pivot table of the data set

[Rajesh_27]

Dear Members,

I am trying to make a pivot from a large data set, attached is the xls with data and Pivot, can you please help me developing the workflow.

[DanM]

@Rajesh_27 I would recommend giving more context and what you've attempted already in Alteryx to resolve your issue. That will assist members in helping you.

[Qiu · Accepted solution]

@Rajesh_27 
I am not sure this is exactly you need, but should help to get started.

[Rajesh_27 · Accepted solution]

Hi Qiu,

Thank you for helping me on this, just one change please. In this workflow total is given based for all the 36 lines in each column, i am looking out to get it based on column QT which means only 12 columns based on QT.

Once again, thank you very much for your help.

[Rajesh_27 · Accepted solution]

hi Qiu, it worked, did small change and its giving me the right result. Thank you so much for your help.