So are the Levels actual hierarchies in Tableau or are they each their own dimension, and the Regions are members in the dimension?
Are you able to provide a packaged workbook (twbx file)?
The levels are each dimensions - I guess the fact that they are in a hierarchy is not important.
Here is packaged workbook that describes the problem. The 'Region Calc' is supposed to calculate which dimension level to use.You can see that Clothes are only made in the East, so I would like 'Region Calc' to use Level 2. The issue is that I have to use Attr() in the calculated field to fix the aggregation error. Maybe the real question is, how do I avoid changing my dimensions to aggregations?
Data_Sales_Region1.twbx.zip 24.5 KB