3 Replies Latest reply on May 7, 2018 4:04 AM by kumar bharat

    Lookup Filter hiding blanks

    Aaron Tan

      Hi,

       

      I am trying to build a table where it shows the past 12 months of data by filtering the lookup date.

       

      I've tried to built it in the way sheet 1 in attached twbx and it shows exactly what I wants. However when I try to add the grand total and for some reason all the blanks calculation came along as shown in sheet 2. I still have my past 12 months of filtering but now it's showing all the grand totals even though I'm having them filtered out. How can I only shows the the data with the grand total for the past 12 months and hiding the rest of the blanks one? **I have to use lookup, direct date filtering won't work for my case scenario**