11 Replies Latest reply on Jun 7, 2018 6:49 AM by dinesh punnam

    Zero's when no data

    dinesh punnam

      Hello all


      I have below sheet and when I select country it is filtering to country  - i want all other countries to show zero ?



      I tried ZN(MEASURE,0) and LOOK UP ()


      Din't work - any help appreciated !!