Pivot Transform Enhancement (Count non numeric data)

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.
Screen Shot 2021-07-05 at 6.49.48 AM

Doesn’t Count do what you want?