Help for omitting records with dates that have multiple price points
I'm a beginner, so any help appreciated! I'm trying to pull data together to calculate price elasticity.
I have a date field and a price (i.e. number) field. I want to perform a bunch of searches for distinct price points (say starting with one for $49) and only find records if on that date we sold the product only for that particular price (it is not sold at different prices that date).
E.g. if on February 2 we sold the same product one time for $49 and one time for $59, I want to omit any records with that date when searching for $49.