I have a fairly simple pivot table and chart showing Members and their
Sales figures.

I can sort by the Dimension members, but when selcting to sort by
Measures I assume it won't let me break the hierarchy, but I cannot
find that as an option..?