Hi @oconnellpatrickc ,
Ensure that you have the ‘fruits’ field added to the visual. Add a filter to the visual to limit data to 90 day period (absolute range or relative filter as your use case requires). Then, add another filter on ‘quantity of fruits’ field for the visual, set the Aggregation to sum (in the filter), Filter condition to Greater than or equal to and the value to your desired cut off.
Above is easiest way to visualize it. If you still have the need to create a calculated field (perhaps for use in some other logic), create a sample analysis in Arena and we can take another look at it. Marking this as solution for now.
Regards,
Arun Santhosh
Pr QuickSight SA