Rank is a little tricky here because of the aggregation and the fact that the data is sparse (not every Institution has every Subtype or Title and not every Subtype has every Title). In previous version of Tableau, before the Rank() function existed, we had to use Index() to make our own Rank. And I suspect that will be the easiest solution here.
As you are able to sort Institution1 the way you'd like, you can then use Index() to simply increment the rows like this:
The trick is to not let any fields be the partition -- so right click the Index field and select Edit Table Calculation...
Then use the drop down option for Compute using: and select Advanced....
Set it up with all fields in Addressing in the order shown below:
and after clicking OK, set the At the level: option to Institution1.
What this does is tell Tableau not to partition Index by anything, but to calculate the Index at the level of Institution.
Hope that helps!
JM - Thank you for the the solution and the quick reply. This worked like a charm! I was able to replicate the results no problem. Thanks for the screen shots and walkthrough. I'll be using ranks like this regularly so it will be a key part of my workflow. Cheers!
You’re welcome! I’m glad it worked!