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

    Filtering PO Number by latest Date

    Dan Maycock



      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)