Add a column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
nbalasub
6 - Meteoroid
06-28-2023
09:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
First time asking a question here. I have only two months experience with Alteryx. So a general sum question from Excel.
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
Labels:
- Labels:
- Error Message
2 REPLIES 2
17 - Castor
06-28-2023
09:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @nbalasub
Based on your description, try using a summarize tool to do the following:
- Group by [F3] (Presumably indicates Taxable/non-taxable.
- Sum [Line Tax Amount]
21 - Polaris
06-28-2023
04:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
