Count String

arnorian_intapp

Hi,

I have a simple spreadsheet with the following fields: account band, account name, product and sales).

I'm trying to create a formula that can count number of products that once i group by customer or account band can see number of products in that field. The product is written as a string (Name of the product).

I have tried COUNT STR(product) to no avail.

I have attached screenshot of sample data and type of output im trying to achieve.

Thanks

Alteryx Product Count.png

Claje

Hi,

You can accomplish this with a Summarize tool and the Cross Tab tool.  In summarize, group by Account Band and Product, and count Products.  Then use the cross tab tool and set your "Account Band" field as the Group By value, set "Product" to headers, and set "Count" to values, and select the "Sum" option.