Alteryx Designer Desktop Discussions

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

Add a column

nbalasub
6 - Meteoroid
 

First time asking a question here. I have only two months experience with Alteryx. So a general sum question from Excel.

 
 

Question 1.JPG

 How do I bring out the total on a line from the True Filter. I need to sum up the True column. If [F3] = "Taxable" then total taxable

2 REPLIES 2
Luke_C
17 - Castor

Hi @nbalasub 

 

Based on your description, try using a summarize tool to do the following:

  1. Group by [F3] (Presumably indicates Taxable/non-taxable.
  2. Sum [Line Tax Amount]
Qiu
20 - Arcturus
20 - Arcturus

@nbalasub 
Welcome to the alteryx world. 😁
You mentioned that about adding one column, so I figured that you need add the column of "Total Taxable back" to the true anchor of filter tool.
I made a quick sample and hope it will help.

0629-nbalasub.PNG

 

Labels