More conditions in Relations

Hey. Hey,

I have a table:
Order_Cost, where I keep track of expenses:
Date | Price | Supplier | YYYY-MM

I have a table:
Dashboard, where I display summary data by month:
YYYY-MM | Count of Orders |,… | Order_Cost Rel

I need to figure out how to display summary data (Price) for each supplier separately in the Dashboard table.

Thank you for ideas!

For this calculation I use SUMIFS in excel.


I feel it is best to add another table with name of suppliers and make a relation between Suppliers table and Order table. Then you can use roll up column to show summary data.

Coming so soon!