It would be awesome if the Pivot Transform had the functionality to Count non numeric data.
You can summarize by Count in Pivot. That works for non-numeric values. If that doesn’t do what you want, can you give me a simple example with an input and the desired ouput?
Counting by text value is useful when prepping data to create a Pareto Chart. For example, imagine we have to analyze defects by manufacturing line. We could get data such as,
A good starting point to begin the analysis would be to count the type of defects by Manufacturing line. I’m keeping it simple. I have a client that has 39 plants in 12 countries.