Pivot table - Simple

[jaywalker12]

Hi, I am trying to do a simple Pivot Table like in excel to just count the open and closed. Is it just the summarize tool?

Example data attached

I have multiple reports, i am isolating a single column in each (different names) and then collating all into one single excel output with each report (pivoted) showing the count. 

[TheOC · Accepted solution]

hey @jaywalker12 

I have built a workflow for you, that produces the output you desire:

Here i am summarising twice, one for the count per record:

and one for the total:

Then i am bringing them together with a union tool, making sure that my second connection (grand total) is at the bottom:

Then im simply using a formula tool, to say that in the row where 'status' is null, change that to "grand total", and here we have our output:

Attached is the workflow,
I hope it helps!

TheOC

[jaywalker12]

Thank you! worked perfectly

[TheOC]

Not a problem at all! glad to hear it!

[jaywalker12]

Hi Quasar, 

Quick question - Happy that if gives the counted values.

However, If I had to isolate the exception message as well to generate a "report" after creating the pivot, is there a way to do it.

Have attached an excel. 

[danloz]

Of course!  

Have a look at this:  

https://help.alteryx.com/current/designer/output-log-file

I've messed with it before, although I find that I rarely need it unless I'm doing something complicated.