Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Adding A New Row & Summarizing Columns Under Each Header

FabianAvina
7 - Meteor

I am trying to recreate an import file I used to create using the pivot function in Excel. Basically, I need it to look like this:

FabianAvina_0-1663084762086.png

Here is the sample data I am working with which includes a tab with what the file should look like. I am close but basically need help adding the row that identifies the tax type with a another column underneath that summarizes the tax amount and nontaxable amoun

4 REPLIES 4
chukleswk
11 - Bolide

@FabianAvina It would be helpful if you posted what you currently have or advise as to what you're joining on and what each tab is for.

 

But from what you have, it sounds like you are going to want to use a Multi-Row formula.

FabianAvina
7 - Meteor

Of course, this is what I have thus far. 

Qiu
21 - Polaris
21 - Polaris

@FabianAvina 
I am working at the later part to calculation.

Please blend with yours.

0914-FabianAvina.PNG

FabianAvina
7 - Meteor

Yes, this worked thus far. Thanks.

Labels