Expression as Set Analysis Modifier

[#1]

Hi,

I am trying to produce a Count of All PO Numbers that have a spend of less than $5000. Each PO can have multiple Line Amounts and hence I need to ensure that sum of all Line Amounts for a PO total to less than $5000.

I tried the below formula but failed. I will appreciate any help.

Count({$<(aggr(Sum([Line Amount]),[PO Number])={"<5000"})>}[PO Number])

[#2]

Thank you! You guys are the bets... Appreciate all the guidance!

Regards,

Deepinder