Set Analysis - Function required to calculate Sales by Sales Invoice

[m_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.

I need the below result:

75

22