How to pivot a report in Alteryx?

[charles7yau]

Hi,

How do I pivot like pivot in excel?

I want to build something like below, I have tried to used the cross-tab tool and summarise tool, I still can't get my resullt.

I have included a sample of raw data for your demonstration.

Thank you so much!

[christine_assaad]

Hello @charles7yau 

I created a report close to what you are looking for. See below

I used a Crosstab followed by couple of multi row formulas to give it a look close to what you are looking for. I also used Crew Macros "Add Totals" (Summarize could be used as well). I'm sure there are different ways to get you there and this is one of the options. WF attached. Cheers!

[charles7yau]

OMG thank you very much for your help. My apologies for the following demand: (I am still a beginner at alteryx)

• Type: Can I just have “A” and “B”? I see here there are repetitive of “A” <same for Sub Type>
• Status: Can we make the “done”, “not done” and “not due” as sub header? “Status” as the header?
• Can you teach me to add row and column total like what you did in macro but in a simpler form? (not macro)?
• Last but not least, can how do we extract our table into excel?