8 Replies Latest reply on Sep 12, 2018 2:38 AM by Amit Darak

    Exclude null values in Bottom 3

    Amit Darak



      I have created a set for bottom 3 in which dimension is selected dynamically using a parameter.


      Issue I face is that in bottom 3 it shows dimensions with null values or 0 values. I tried using the measure as filter as well but then it does not show top 3. Instead it exclude null values and shows only top 2 or in other parameter selection like city it shows no values.


      So for example bottom 3 states should be  - Telangana, Andhra Pradesh, Haryana


      Bottom 3 cluster should be - Sirsa, Nizamabad, Akola


      Bottom locations should be - Bhatinda, Bhojpur, Narwar


      Unable to do this.