Now since I have different levels in my chart because of the group dimension I need to rework my expression to include the Entity, Dept, and Provider in the AGGR depending on the level I go to.
However, this expression is not working at all. Basically if a provider is selected then I need it to follow that logic provided above and so on. Now the logic works if I only have one IF statement but doesnt supply me with the correct answer when I add a second IF statement. So I think I'm doing something incorrectly with my IF statement.