hi

[abc_777]

for RFM i have 

Segment Score Index
Champions 555 1
Champions 554 1
Champions 544 1
Champions 545 1
Champions 454 1
Champions 455 1
Champions 445 1
Loyal 543 2
Loyal 444 2
Loyal 435 2
Loyal 355 2
Loyal 354 2
Loyal 345 2
Loyal 344 2
Loyal 335 2
Potential Loyalist 553 3
Potential Loyalist 551 3
Potential Loyalist 552 3
Potential Loyalist 541 3
Potential Loyalist 542 3
Potential Loyalist 533 3
Potential Loyalist 532 3
Potential Loyalist 531 3
Potential Loyalist 452 3
Potential Loyalist 451 3
Potential Loyalist 442 3
Potential Loyalist 441 3
Potential Loyalist 431 3
Potential Loyalist 453 3
Potential Loyalist 433 3
Potential Loyalist 432 3
Potential Loyalist 423 3
Potential Loyalist 353 3
Potential Loyalist 352 3
Potential Loyalist 351 3
Potential Loyalist 342 3
Potential Loyalist 341 3
Potential Loyalist 333 3
Potential Loyalist 323 3
New Customers 512 4
New Customers 511 4
New Customers 422 4
New Customers 421 4
New Customers 412 4
New Customers 411 4
New Customers 311 4
Promising 525 5
Promising 524 5
Promising 523 5
Promising 522 5
Promising 521 5
Promising 515 5
Promising 514 5
Promising 513 5
Promising 425 5
Promising 424 5
Promising 413 5
Promising 414 5
Promising 415 5
Promising 315 5
Promising 314 5
Promising 313 5
Need Attention 535 6
Need Attention 534 6
Need Attention 443 6
Need Attention 434 6
Need Attention 343 6
Need Attention 334 6
Need Attention 325 6
Need Attention 324 6
About To Sleep 331 7
About To Sleep 321 7
About To Sleep 312 7
About To Sleep 221 7
About To Sleep 213 7
About To Sleep 231 7
About To Sleep 241 7
About To Sleep 251 7
At Risk 255 8
At Risk 254 8
At Risk 245 8
At Risk 244 8
At Risk 253 8
At Risk 252 8
At Risk 243 8
At Risk 242 8
At Risk 235 8
At Risk 234 8
At Risk 225 8
At Risk 224 8
At Risk 153 8
At Risk 152 8
At Risk 145 8
At Risk 143 8
At Risk 142 8
At Risk 135 8
At Risk 134 8
At Risk 133 8
At Risk 125 8
At Risk 124 8
Cannot Lose Them 155 9
Cannot Lose Them 154 9
Cannot Lose Them 144 9
Cannot Lose Them 214 9
Cannot Lose Them 215 9
Cannot Lose Them 115 9
Cannot Lose Them 114 9
Cannot Lose Them 113 9
Hibernating customers 332 10
Hibernating customers 322 10
Hibernating customers 231 10
Hibernating customers 241 10
Hibernating customers 251 10
Hibernating customers 233 10
Hibernating customers 232 10
Hibernating customers 223 10
Hibernating customers 222 10
Hibernating customers 132 10
Hibernating customers 123 10
Hibernating customers 122 10
Hibernating customers 212 10
Hibernating customers 211 10
Lost customers 111 11
Lost customers 112 11
Lost customers 121 11
Lost customers 131 11
Lost customers 141 11
Lost customers 151 11 

numbers. here score are only 3 digits. but i want 4 digits like 5555 all the way down to 1111. i have 625 numbers. but dont know how to fill with segments. can some one help me the tricks how to fill 625 numbers accordingly to segments 

i cant pase 625 numbers of four digist combination here as it exceed limit of 20,000 character. 

 please guide me how i fill. i give few example numbers

1111
1112
1113
1114
1115
1121
1122
1123
1124
1125
1131
1132
1133
1134
1135
1141
1142
1143
1144
1145
1151
1152
1153
1154
1155
1211
1212
1213
1214
1215
1221
1222
1223
1224
1225
1231
1232
1233
1234
1235
1241
1242
1243
1244
1245
1251
1252
1253
1254
1255
1311
1312
1313
1314
1315
1321
1322
1323
1324
1325
1331
1332
1333
1334
1335
1341
1342
1343
1344
1345
1351
1352
1353
1354
1355
1411
1412
1413
1414
1415
1421
1422
1423
1424
1425
1431
1432
1433

[Greg_Deckler]

@abc_777 Not entirely sure exactly what you want but maybe something like this?

Table = 
SELECTCOLUMNS(
    ADDCOLUMNS(
        GENERATE(
            GENERATE(
                SELECTCOLUMNS(GENERATESERIES(1000, 5000, 1000),"Thousands", [Value]),
                SELECTCOLUMNS(GENERATESERIES(100,500,100),"Hundreds", [Value])
            ),
            GENERATE(
                SELECTCOLUMNS(GENERATESERIES(10,50,10),"Tens",[Value]),
                SELECTCOLUMNS(GENERATESERIES(1,5,1),"Ones",[Value])
            )
        ),
        "Number", [Thousands] + [Hundreds] + [Tens] + [Ones]
    ),
    "Number", [Number]
)

[abc_777]

Hello @Greg_Deckler ,

i already generate 4 different types of number by using excel

1111
1112
1113
1114
1115
1121
1122
1123
1124
1125

.......

5555

my requirement is i want to assign all 11 segments like Champions , Loyal ,Potential Loyalist  etc etc all 11 segments according to 

1111
1112
1113
1114
1115
1121
1122
1123
1124
1125

.......

5555

i have given example of  3 digits to above. i dont know 1123 is this number is Champions or Loyal  or which one in 11 segments