In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data Summary

knnwndlm
8 - Asteroid

Hi SME,

 

In the attached file, I have the Source tab.  How do I get to the Desired Output tab?  In essence, I'm trying to format the report in a way that's like a pivot table in Excel.  I've attempted to create a workflow to do so but it got way complicated and I'm not able to create the subtotal under each category.  There's got to be a more sensible way to do this.  Appreciate your help.

 

Thanks,

Konn

 

5 REPLIES 5
TimN
13 - Pulsar

Hi,

Something like this?

PanPP
Alteryx Alumni (Retired)

Hi @knnwndlm 

 

I have provided a sample WF that matches your output.

 

 

knnwndlm
8 - Asteroid

Thank you so much @PanPP!!

TimN
13 - Pulsar

Hi,

@PanPP @knnwndlm ,

The Data Types are incorrect in the Select Tool 75.  You need to update that to Fixed Decimal.

 

Tim

TimN
13 - Pulsar

It's also affected by the "-" coming in from the data to represent null or zero.  I think you need to convert that to a null or zero and then convert the columns to fixed decimal.

Labels
Top Solution Authors