What you are trying to do is a computed sort check out the post above.
Let me know if you are still having difficulty and I can assist.
The issue is that when I right-click on the dimension (Organization Name) in the rows area the sort option doesn't show up. I am trying to sort the rows based on grand total, but for some reason it won't display the option to even sort.
The issue is occurring because of the blended data source.
You have organization name on both data sources and it is the linking field
is there any reason you cant use organization name from the same datasource in this view??