SORT BASED ON CALCULATION
I'm a new FM Pro Advanced 11 user, so I apologize in advance for my novice question!
I have table with the following fields:
I need to create a calcuation that counts each occurance of a particular CDC_NUM. In other words, in this table, there will be numerous records with the same CDC_NUM. Then, I need to be able to sort in order of the number of occurance. The end goal is display the most active CDC_NUMs.
I've created Calculation and Summary fields that count the number of occurances; however, I'm unable to Sort or Find these fields in my layouts.
Thanks in advance for your help!