Hi All,
I've met a problem.
I've got a sales table
For example:
| CustomerName | Cost |
|---|
| A1 | 10 |
| A2 | 20 |
| A3 | 30 |
| ... | ... |
| A1000 | 10000 |
they'll order by Cost,then divide the 1000 people into 10 groups:
GROUP1 SUM(COST)
GROUP2 SUM(COST)
GROUP3 SUM(COST)
GROUP4 SUM(COST)
GROUP5 SUM(COST)
...
GROUP10 SUM(COST)
FOR furthur I can drill down to GROUP 1 THEN 100 people will be divided into
10 groups each group contains 10 people,again and again.
How can I achieve this function?
Thanks in advance.
