Count of A's in Each Customer’s Name

How many A's does each Customer have in their name(On Superstore Data)?

Step 1:

Create  3 calculated fields “Cust Name WithOut A's”, “Name length”, and “Name Length WithOut A's”  by below formulas.

Step 2:

Create “Number of A’s” calculated field to find no of A’s in each and every player.

Step 3:

Drag and drop “Name” dimension field into rows shelf and “Number of A’s” measure field into columns shelf.

Thanks Guru's,

Prazval.ks