Create a Calculation to get the first alphabet of the customer name.
Graphical user interface, text, application Description automatically generated
Now drop the First Alphabet field to Rows and Quantity field to the Text on the Marks card. Change the aggregation from SUM to AVG. Your view will look like this:
