Circular dependency error

[learner03]

I have just one table and that contains a column sixe with sixes as- 2,8,4,6,M,L, 3XL etc. I need to sort them.  For this I created a new coloum called sortOrder and used an If condition-

SortOrder = IF(Table[Size (Apparel)]="2",1,IF(Table[Size (Apparel)]="4",2,IF(Table[Size (Apparel)]="6",3,IF(Table[Size (Apparel)]="8",4,IF(Table[Size (Apparel)]="10",5,.........Till all sizes till 38 sizes and  at last Table[Size (Apparel)]+38))))))

After that on Size coloumn I used sort by SortOrder-

But, it gives me below error( Blue is Table name-

How can I sort sizes in the form 0,2,4,6,8..S,M,L,Xl.2Xl...so on?

[amitchandak · Accepted solution]

@learner03 ,

Do it like this

refer: How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

Size (Apparel) 1 = [Size (Apparel)]

SortOrder = IF(Table[Size (Apparel)]="2",1,IF(Table[Size (Apparel)]="4",2,IF(Table[Size (Apparel)]="6",3,IF(Table[Size (Apparel)]="8",4,IF(Table[Size (Apparel)]="10",5,

//other

(Apparel)]+38))))))

then

sort : Size (Apparel) 1  on SortOrder

That will not give a circular error