No, Apsona does not support sorting by calculated fields. Since these fields are generated at runtime, they are not available in the sort picklist or query logic—either in single-step reports or merge actions.
Limitation: Calculated fields cannot be used for sorting.
Reason: These fields are generated only at runtime and are not stored values.
Workaround: Create a formula field in Salesforce on the underlying object (e.g., Affiliation). This makes the value available for sorting in Apsona reports and merges.