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 !!