10 Replies Latest reply on Jan 15, 2020 10:50 AM by Jyoti Singh

    Set the 2nd Quick filter to All when the 1st quick filter have no items

    Jyoti Singh

      Hi

       

      I hope you can help.

       

      I have one field name Status which have two values Current and Completed. If any product don't have any current status then it should show all the products which are in completed status else show the relevant values.

      Please check the attached sample worksheet.

       

      For example, under the LOB - Bank, when I set the status to current, the chart go blank but for LOB Hospitality it is showing me data because we have data. So, the problem is my customer wants if there is no any data in current then it should show all else the current data.

       

      I'd appreciate any help you can give.

       

      Many thanks