Newbie to FileMaker Pro 15 (Mac) and I can't seem to figure this out after loads of trying and searching. Hopefully I can explain this.
I have two fields which we'll call A & B.
Both fields have data in them that's more or less like this:
Field A: 1, 2, 3, 4, 5, 6, 7, 8
Field B: apples, oranges, apples, apples, oranges, apples, apples, oranges
Field A is related to B in that if Field A #2 is related to oranges.
I can easily make a chart that will plot B against A (A on x-axis).
But what I want to do is make a chart that plots just the oranges in B against A.
Does this make sense? In other words, how do I just select specific data points in field B to consider and not the entire data set in field B?
Many thanks, and apologies if this is way to easy....