I've searched the forums/openstack/etc and I feel like I may not be using the correct phrasing. What I'm looking for is how to filter data based on 2 categories of data stored in one table. For example, table 1(parent table) has fruit name and table 2 has size and color with fruit name as the key field for joining. What I'm able to do so far is drill down by size OR color OR shape, rather than using AND logic and show the overlap in months. EG filter by color: red and show the sizes of red fruit and the average growing season in number of months(this is a calculated field). See the tables below
|Fruit Name||Grow start||Growth End|
I figured out a work around. I joined twice by pulling in color and size separately with AND logic at the joins.