Selective Max and Min Values
I am trying to use a calculation to find the MIN and MAX values from a certain field. But I only want to use the values in that field that are present when another field has a specific value.
Table 1: So, in one field I have a value list, where I pick a shop: Grocery Store, Bakers etc. Then another value list field with products: Apple, Pear, Orange etc. Then I have a number field where I insert the price.
Table2: Now, in the Grocery Store table, I want to create a field that will tell me the maximum price paid for an apple. But how do I create a calculation that will only select the values in the price field when the product field says "Apple"?
Any help with this would be greatly appreciated,