1 Reply Latest reply: Jul 17, 2018 3:36 PM by Danny Selgo RSS

    TOTAL Qualifier with Alternative Dimensions

    Danny Selgo

      Hello, I am having a problem with using the TOTAL qualifier on a chart that makes use of different alternative dimensions.

       

      Basically, I have a stacked bar chart that is showing demographic information for a population. I want to show the percentage breakdown of the population by different dimensions (e.g. Ethnicity, Gender, etc.).

      scrshot1_07172018.PNG

      My expressions for this chart is:

      count([Person]) / count(TOTAL<[Ethnicity]> [Person])


      This gives me the ideal behavior for the chart. The issue is when I introduce alternative dimensions. For example, the following chart where the dimensions are switched:

      scrshot2_07172018.PNG

      Because the TOTAL qualifier is still excluding <Ethnicity>, my chart is not behaving how I want it to. Basically, I want to be able to set the expression to something like the following:

      count([Person]) / count(TOTAL<["X-axis Dimension"]> [Person])


      Does anybody know how I could accomplish this?