Summarize if-condition meets

Question

Hello,

I have below table

Company 11Company 21Company 12Company 33Company 14Company 31Company 21

And I like to display it in below format with one record for each company, and the number of occurrences of each number counted. IT is similar to countifs formula of Excel. How can I achieve this in Alteryx?

Count of 1Count of 2Count of 3Count of 4Company 11001Company 20200Company 31010

binu_acs · Answer

@concel One way of doing this

Summarize_0920.yxmd

Emmanuel_G · Answer

Hi @concel ,

Find attached the way of doing this.

Let me know if there is any issue and do not hesitate to mark this answer as solution if it helped.

Summarize if-condition meets.yxmd