13 Replies Latest reply on Jan 11, 2019 1:06 PM by Vikram Gokhale

    Filtering PO Number by latest Date

    Dan Maycock

      Hello,

       

      I have a workbook that lists an item then shows all POs for that given item. I only want to show the latest PO for that item though, by the latest request date.

       

      I've seen instructions online to use {FIXED[PO Number]:MAX([Date Requested])} but am not sure how to actually filter the list of POs to use this calculation via a boolean filter, so I'm half way there.

       

      Any suggestions on how to filter the PO list using this calculation (which shows the latest date for a PO)

       

      Thanks,

       

      Dan