, Thank you very much for the reply. My code starts with 0 and ends with Character. There are couple of characters (SME, AME CLS CLR ECS TAR) and Numeric code ranges from 0 to 180. My data set totally consists of 1211456 observations (This is nothing but the total Members I used as No here in above examples).Based on payment type on month basis how many total members are under bad rate. I need to generate report based on month wise how many members are bounced. We are basically considering the last 3 months (Jun,Jul,Aug). Im not supposed to post data here. Thats the reason I created sample data and posted here.
... View more