How to design BEX Query senario??

I have a senario in BW Query designing

ID DESC

1:10 Dealer-New

2:11 Dealer-refinance

3:20 Direct-New

4:21 Direct-refinance

5:30 Franchise-New

6:31 Franchise-refinance

We have developed this BW Query

Now main problem in we need output as bellow

ID DESC

1:1 Dealer

2:2 Direct

3:3 Franchise

How to design BEX Query above senario