has anyone tried to use sum/* comment */ Field over(partition by Field order by field) in saved search’s criteria?

I tried but ended up changing my approach because it didn't work out in my case

It is giving me an error. I am wanting to ahow list of all items per location where total of on hand of all locations are more than 3.

Send your search criteria and see if anyone is able to help