Also, I have a calculated field called sales status. this field does the following if a sales have been made to a customer it will become 'Partially Reached' if nothing has been sold to the customer it will become 'Not Sold To' if the salesmen have exceeded his target per the client it will become 'Target Reached'
I want to display this field 'Sales Status' breakdown in a pie chart for the top 100 customers per that sales rep
Please see attached I have this split working with KPI's but I cannot get it to work with a pie chart the problem is the pie chart keeps on displaying the breakdown of all customers in total and not per 100 per salesrep as i want it. if i do a selection on 100 it works