Hi X T,
Sorting a Dimension Pill (even using an aggregate for that)
doesn't take into account any other Pill that might be on a view.
Think of it as if the actual sorting happens before rendering a view.
With that in mind it is easy to witness the seemingly 'strange' behaviour
of your 'Day Number & Month Name' combined Dimension Pill,
as it may contain a single Date (from either Year) or many (from several Years),
thus giving a different result when sorting by MIN(Date) or MAX(Date).
Please find the attached as an example.
Sort_Dim_by_Agg_v10.2.twbx 2.4 MB