3 Replies Latest reply on Mar 21, 2018 2:23 AM by Mansi Bhandari

    Displaying Null or Zero when specific value is selected from the filter.

    sudhir ranajn

      Hi Experts,

       

      Can I display null or zero for any metric when a specific value is selected from the filter ?

      In my attached worksheet, I am displaying sales value which is filtered by 'category' and 'Sub-category'.

      Each filter has <select> option embedded. When I choose <select> option from drop down then my sales value goes blank

      and if I select category or sub-category from drop down, it shows the respective sales values. But my scenario is like I wanted to

      show NULL or ZERO when category and sub-category option is selected from the filter instead of data.

       

      Seeking Your Help.

       

      Regards,

      Sudhir

       

      Jonathan Drummey

      Rishabh Dhingra

      Zhouyi Zhang

      Tushar  More