Matrix sorting with Column groupings issue

Basically your issue is that you need to sort the food rows, and you want to do this by selected a food group (columns). The problem here is that you can't sort items in the row group scope from an item in the column group scope.

For this to work you'd need to create a textbox or similar outside of the column group, which would then let you sort the row groups.

---

David Stewart | My Microsoft BI Blog | @dstewartbi