I don't see any straight forward way to achieve this, You can get top 10 rank but this will ignore remaining records, I'll check if i can find some work around,
Which version of Smart Reporting you are on ?
The version that we use is the 9.1.
Thanks for replying so fast.
1 of 1 people found this helpful
You can try this by using Sub-query Option within the reporting. Do the top 10 List in your main Query and make the sum of all in sub query and make a union join. you may have to play with calculated fields to get the sum of only top 10 in the sub query or you have to some how manage to get only top results to the sub query report.
main query top 10 +subquery Union all +sub query sum of top 10 = 11 records in report.
then you can create the Graph out of it.