Set Analysis - Sales by Invoice no

[Mohammad_Adnan_Ansari]

I have the below Sales Table:

Invoice No  Item No   Sales Amount

1                     22               25

1                     101             5

1                    5                   45

2                    23               22

I need a Set Analysis function to get Sales by Sales Invoice No. I basically first need to find sales by Invoice and then segregate the sales by buckets. 1-10, 10-20 and so on.

The results needed are:

75

22

so the first one will go to 70-80 bucket and other one will go to 20-30 bucket.