Apologies for the ambiguity.
I have a list of clients and sales over 3 years and 10 sales divisions.
The end result I want is to create a chart/pie chart that shows:
sales of clients who have dealt with all 10 divisions,
sales of clients who have dealth with 9 divisions,
sales of clients who have dealth with 8 divisions,
sales of clients who have dealth with 7 divisions etc....
I used the aggr(count(distinct division), client) to create the appropriate buckets in a LIST BOX but i'd now like to create a new field named 'Clients and number of divisions'. This would presumably allow me to create a pie chart with each slice being 10,9,8,7...etc.
If I write this into the script, I'm wondering what the syntax would be or if there is a better solution that would be great.