Hi Zach - good point.
For getting "Top N + Other" in the pie chart, there were two choices:
- There is no out-of-the-box functionality to enable the rest of the data rows to appear as "others" group in the chart. However, this grouping can be achieved using a group expression containing a conditional function that calculates the Top N lower bound data point.
- Another approach is to modify the data rows before passing them to the Graph item and add some of the rows to a new "others" group. This can be achieved using the ObjectDataSource Component.
I can't remember if I tried either of these. The reports as I view them today doesn't use the Top N feature and they're ugly. Apparently I explained the investment and performance hit required to accomplish this with Telerik Reports and the customer decided what we had was good enough.
For the sorting, the resolution was straight-forward: "You have to apply the sorting on the series group you're using in your PieChart. This will allow the series to be ordered by the evaluated result of the aggregate function you use in the sorting expression."