We have a requirement where we need to list TOP 15 values based on Dollar amount and the 16th Row should be the "OTHER" comprising of all the values not in TOP 15.

See attached file for more clarity:

Could you please help us in developing this query?

Thanks,

Kumar