12 Replies Latest reply on Feb 6, 2019 2:16 PM by Avinash Pallapotu

    Fill Blanks / Missing Data with '0' or KPI when a quick filter is applied

    Avinash Pallapotu

      I am using Superstore data set for this scenario, I am aware that we can use ZN(Lookup) function to fill blanks, this method works perfectly fine when we have no quick filters.

      The issue is ZN(lookup) wont work when we add a quick filter to the view.

      In the attached workbook, I added 2 sheets, One with quick filter & one without.

      Any help or tips is very much appreciated.