This content has been marked as final. Show 4 replies
Let's assume I have a table with a simple structure:
I would like to ORDER the records by Value (ascending) and then SPLIT the records in 10 sets, each set HAVING THE SAME sum(Value) - that is sum(TOTAL Value)/10.
The end result would be a chart showing all those 10 sets and the number of records contained in each set. Something like this:
Could anyone please suggest a solution for this?