Add sorting of Small Multiples

I would like to be able to use small multiples to show pareto charts (using a stacked column chart) for various years (e.g., 2018, 2019, 2020, 2021) where the x-axis (Product Category) will adjust for each small multiple based on the highest to lowest value of the y-axis (e.g., revenue).  This means the x-axis would need to appear with each multiple since sort order could be different in different years.  Currently the pareto charts don't sort from highest to lowest since the "Sort Axis" just sorts the Product Category names alphabetically (instead of by the corresponding value of the y-axis).