3 Replies Latest reply on Sep 21, 2018 11:02 AM by Alan Perez

    v10.5 - Showing most recent, non blank item

    Ryan Soares

      In the attached data below I have a list of projects in different months. Each project has an assigned owner in each month with some being blank. I want to build a simple table to show the project name and its owner for the most recent month that is available in the data that is not blank. If the most recent month is blank, then go back to previous months and show the previous owner. Only show a blank if all entries for that project have a blank owner.

       

      For the sample data the table would be:

       

      Any help is appreciated, thanks!