This content has been marked as final. Show 3 replies
I have a bar chart that shows total number of Sales by Sales Rep Names
I want to show total number of sales reps on the title so the users would know exactly how many sales reps are there.
I am using following expression as the title of that chart
='Total Sales by ' &count(Distinct(RepName)) &' Sales Reps'
What is the best way to write above expression to manage Singular & Plural?
Example : If there is only 1 Rep selected then the title should say 'Sales Rep' instead of 'Sales Reps'