3 Replies Latest reply: Feb 9, 2018 2:39 PM by Digvijay Singh RSS

    Drill Down Second Level Issue

    Ahmad Shawahna

      I have implemented drill-down to show the percentage of mobile voice users as the following:

      Measure:

      Count({$<[Use of Mobile Voice Service]={"Yes"}>} [Use of Mobile Voice Service])

      /

      Count([Use of Mobile Voice Service])


      Dimension:

      Level 1: Year

      Level 2: Operator


      The problem that the second level of drill-down is using only those "Yeses" which makes the above calculation is 100% for all operators.