Countif function

[Jenina]

Hello All,

I am trying to do a simple countif in Alteryx but it looks like it's not straightforward. 

I just wanted to count the currencies per Account unit. Please see below sample. Thanks for the help.

Source:

Account unit	Currency
UNIT 113	EUR
UNIT 113	EUR
UNIT 113	EUR
UNIT 113	USD
UNIT 113	USD
UNIT 112	EUR
UNIT 112	EUR
UNIT 112	USD
UNIT 112	USD
UNIT 112	USD

Output:

Row Labels	A Account	B Account	Grand Total	Item Count
EUR	-165522.27	192850.67	27328.4
unit 113	31652.24		31652.24	3
unit 112	-65.64	-0.01	-65.65	2
USD	-165522.27	192850.67	27328.4
unit 113	31652.24		31652.24	2
unit 112	-65.64	-0.01	-65.65	3

[geraldo · Accepted solution]

@Jenina 

An example workflow of how to get the result you want

[Jenina]

@jdminton  this works! and yes it's complicated. Thanks!

[Jenina]

@geraldo this is amazing, thank you!

[jdminton]

I’m glad it works for you. You can do something similar with reporting tools but I find those less useful if you’re going to use the same data downstream.

[Jenina]

@geraldo going back to this, If I want to add an Inventory column, where should I place in the 3 summarize tools that will still result to the same output we have.