Is it possible to create a pie chart that lists the top data - user defined or scripted - and lumps the other data into a category called "Other"? For instance, if I show a data set in a pie chart and there are too many slices, I'm wondering about grabbing just the top five sets (using a summary count) and listing all the rest in "Other".
Similarly, how would I grab just the top five sets and not display "Other"? Please see attached for examples.
You could build the chart via a sorted relationship and then grab the first five rows (using getvalue or a CF to do that) + a hardcoded "¶Other". In the data section you could then get the top five again + "¶" & total count - top five counts.