More conditions in Relations

Ask for Help
1

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!

2

For this calculation I use SUMIFS in excel.

3

Hi,

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.

4

Coming so soon!

4 Likes