I have a set of data, and I want to group by "Product" and subtotal each grouping. However, the product is a string not a number value.
With the Summarize tool, have you tried Group By Product, and Count Product?
Chris
It would be great if you could share sample data. You can use the summarize tool to Group By Product and take the count. Once you group by a String Data Type you can take the count of the Grouped Values. If there is another numeric value associated to the Product, then you can invoke the sum in the summarize tool.
Yes, that does give me a count, but I looking for a subtotal view with the count below the grouping (like a pivot table)
thanks, yes that does give me the count. However, I am looking for more of a subtotal line below the grouping (like a pivot table)
Thank you. I am going to try this and see if get the desired results and report back.