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 |
Solved! Go to Solution.
@jdminton this works! and yes it's complicated. Thanks!
@geraldo this is amazing, thank you!
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.
@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.