I have the following 3 tables:
- Brand: Text
I would like to create an aggregated list of the chocolates grouped by the color AND the taste, by counting the number of brands within that type (color+taste). Aggregation works if I use only one table, but then of course the other table will be disregarded. How can I do that with both two tables?
I also tried SQL solution, but the GROUP BY from joined tables does not seem to work in FM (query result: "?")
e.g.: Chocolate table
I would like to have the following query result:
I would really appreciate any help!
Thank you very much.