I am trying to filter my data by Opportunity ID and then type Cat and Dog, my formula is is not providing any data.
Amount Cat & Dog =
This is the result I am trying to get
In addition ( I haven’t got to this yet), I would also like all types associated with Cat
Any guidance would be greatly appreciated…I think I am closeDNA test CalculateFilter.pbix (30.8 KB)