1 of 1 people found this helpful
There's probably a slightly easier way to mask these, but there's nothing terrible about your approach. I'd adjust your Table Calculation to be sorted on Specific Dimensions, and place them in the following order:
- Sort Masked Names
- Display Name
- Month of Order Date
Then make sure the level is set to Sub-Category. My general advice is to always arrange the fields in the way they appear left-to-right on your columns shelf (this gets more complicated if you have a dimension rows as well).
It took a little more digging but I figured out that I had to compute by the specific dimensions 'sort masked' and 'sub-category.'