Create calc as [first letter]
Create parameter and string and list add [first letter]
Create 2nd calc as [Selected and others]
if [Calculation1]=[Select Name First letter] then [Customer Name] else "Others" end
Drag this calc into row and show parameter control and select letters.
Create new calc as [selected count and others]
if [Calculation1]=[Select Name First letter] then "Selected" else "Others" end
Drag this [selected count and others] into row and drag customer name into text and select count.
now we can get selected and other count and also selected customers and others data in view.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...