We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
19 - Altair
19 - Altair

@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