1 Reply Latest reply on Feb 23, 2017 8:12 AM by Sherzodbek Ibragimov

    HOW TO HIDE EMPTY CELLS IN TABLE CALCULATIONS WITHOUT USING FILTER

    ravindra babu

      I HAVE A TABLE CALCULATION FOR FINDING TOP 10 CUSTOMERS

       

      IF RANK_DENSE(SUM([Sales]))<=10 then SUM([Sales]) END

       

      hide empty cells.jpg

      I got nulls as above. now i want to display only required values by hiding empty cells. I don't want to use Filter for hiding. how to achieve this?