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

# Filtering PO Number by latest Date

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

• ###### 1. Re: Filtering PO Number by latest Date

{FIXED[PO Number]:MAX([Date Requested])}=[Date Requested]

Drag this to Filter and Set TRUE

• ###### 2. Re: Filtering PO Number by latest Date

I did that, but it had no impact on the report

• ###### 3. Re: Filtering PO Number by latest Date

can you paste some fake data?

• ###### 4. Re: Filtering PO Number by latest Date

Yes, please see attached workbook using superstore data. I've recreated my data issue using this workbook to illustrate the problem.

• ###### 5. Re: Filtering PO Number by latest Date

I am at lower version at this moment. can you not use hyper extract and save in lower version for me to open.

• ###### 7. Re: Filtering PO Number by latest Date

Oh Sorry but it should be .twbx not .twb

• ###### 9. Re: Filtering PO Number by latest Date

do you think we need to include the item# also somewhere in the formula

something like :

{FIXED [ITEM-NO],[PO Number]:MAX([Date Requested])}=[Date Requested]

I feel this should give the latest PO for that particular item.

• ###### 10. Re: Filtering PO Number by latest Date

I am told I need a second formula to compare against this filter to get the PO to compare against the latest PO which I'm unclear on how to make. Making the change you suggested however, then dragging to the filter line didn't filter anything.

• ###### 11. Re: Filtering PO Number by latest Date

Somehow not able to open at this moment but will revert ASAP

• ###### 12. Re: Filtering PO Number by latest Date

It's using superstore data, so can I resend twb file as you should have that data locally installed? Is there a way to export to older version pre-10.5 without Hyper?

• ###### 13. Re: Filtering PO Number by latest Date

Please check attached. it will allow selecting Product Name, for selected one, it will list the latest Order.

Let me know you need something else.