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

    Exclude null values in Bottom 3

    Amit Darak

      Hi,

       

      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.