Filter and Sort order help

[amit_saini]

Hi Folks,

Need help on below scenario:

I'm having 30 thousand records like below

PSD	Number	Sales
91002 (a)	123	10
91002 (c)	123	20
91002 (gs)	123	30
91002	123	40
91002 (ngs)	123	50
91002 (pc)	123	60
91002 (pgs)	123	70
91002 (pngs)	123	80
91002 (re)	123	90
91002 (sun)	123	100
91004 (a)	456	110
91004 (c)	456	120
91004 (gs)	456	130
91004	456	140
91004 (ngs)	456	150
91004 (pc)	456	160
91004 (pgs)	456	170
91004 (pngs)	456	180
91004 (re)	456	190
91004 (sun)	456	200
91002	123	210
91004	456	220

and have to filter the data by PSD in such a manner that first it should show from above data e.g 91002 ,91002 (c) and 91002(pc) , so onlt the 5 digit number followed by (c) value and last (pc) value.

I need to apply this filter before loading the data and once this is loaded I want Output like below:

PSD	Number	Sales
91002	123	210
91002 (c)	123	20
91002 (pc)	123	60
91004	456	220
91004 (c)	456	120
91004 (pc)	456	160

Note: In PSD field 5 digit number and their respective (c) and (pc) value can be random and not available always together , but we have to filter the data first and then need to show output as above.

Please help how this can be possible!

Thanks,

AS

[vvira1316]

Sort Expression changes

PSD_NumericPart & If(SortOrder < 10, '0' & SortOrder, SortOrder)

[vvira1316]

Hi Amit,

Can you please close the thread if you have got the solution?

Thanks,

Vijay