How to create Top 10 and Sum remaining non-Top 10 as one single line item?

[#1]

Query: how to get the desired results from data below?

Data

RANK	CTPY	AMT
1	A	15
2	B	14
3	C	13
4	D	12
5	E	11
6	F	10
7	G	9
8	H	8
9	I	7
10	J	6
11	K	5
12	L	4
13	M	3
14	N	2
15	O	1

Desired results

RANK	CTPY	AMT
1	A	15
2	B	14
3	C	13
4	D	12
5	E	11
6	F	10
7	G	9
8	H	8
9	I	7
10	J	6
REMAINDER		15

Thanks!

[raynac]

This is very helpful, thank you for this great resource!

Does anyone happen know if you can also get a total/sum of the Top X, before printing the remainder??