Need solution to display a calculated rank for lower levels of dimension not displayed in view.

I need an approach to display a calculated rank for a level in hierarchy not included in the display view. Using the Superstore data set, a simple example is attached. On Sheet 1 I have Segment and Sub-Category displayed, along with sales and a calculated rank for each Sub-Category within each Segment.

Using the Accessories Sub-Category as an example, the ranks are:

Consumer = #6 Rank

Corporate = #7 Rank

Home Office = #8 Rank

I want to return those same ranks (6/7/8) for each respective Segment, when the Sub-Category dimension is removed from the view and view filtered to only the Accessories sub-category. See Sheet 1 (2)