4 Replies Latest reply: May 21, 2018 5:30 AM by Jason Zhu RSS

    How to set variable to associated dimension value

    Jason Zhu

      For example I have two dimensions State and City. When I select or filter for San Francisco, I would like a variable to equal the associated dimension California (from the State field). My data structure works in such a way where based on the measure I need to create, California is not automatically associated and identified.

       

      I feel like this can be done using the p() function or agg but I'm not sure how to?

       

      Thanks so much!