In Sense go to edit mode of the sheet. Select the Bar Chart en look at the properties window on the right side.
Choose your dimension field and expand it. Deselect Auto sorting and check Sort by expression. Put in your calculation for the Closed items and choose Descending or Ascending. Uncheck the other options if you don't want to sort on these too.
Hope this helps.