7 Replies Latest reply on Nov 18, 2017 4:16 PM by Steve Gesuale

    Help with calc based on parameter and dimension hierarchy

    Steve Gesuale

      Hi,

       

      I'm looking for some help with a calc.

       

      Region and Country dimensions are hierarchical. I’m trying to build a calc that will return the Region value based on the value of a country parameter. For example, if Italy is chosen via the parameter, I want Europe returned.

       

      Tried this but no luck…

      { INCLUDE : [Region] , ATTR(STR([Country Parameter])) }

       

      Thanks for any help!

      Steve