10 Replies Latest reply on Mar 30, 2018 5:04 AM by chaithanya n

    Display No Data

    Anshul Sharma

      Hi Guys,

       

      i have one question.

      executive_filters.PNG

       

      have a look at the above image, currently "Brand Momentum" is selected in category and "2016" in year.

      data for Brand momentum is not present in year 2015 so if a user selects 2015 and Brand momentum I want to display a message "No data is present " . the problem is

      i am unable to  apply the filter to the sheet which contains the error message as the combination "2015 & Brand Momentum" does not exists in data.

      please let me know how can i achieve this.

      thanks