# More conditions in Relations

**URL:** <https://community.glideapps.com/t/more-conditions-in-relations/60278>\
**Category:** Ask for Help\
**Created:** [April 8, 2023, 7:59am UTC](https://community.glideapps.com/t/more-conditions-in-relations/60278 "2023-04-08T07:59:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Josef\_P](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/josef_p/32/55054_2.png) [@Josef\_P](https://community.glideapps.com/u/Josef_P)\
**Post date:** [April 8, 2023, 7:59am UTC](https://community.glideapps.com/t/more-conditions-in-relations/60278/1 "2023-04-08T07:59:41Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![Josef\_P](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/josef_p/32/55054_2.png) [@Josef\_P](https://community.glideapps.com/u/Josef_P)\
**Post date:** [April 8, 2023, 8:07am UTC](https://community.glideapps.com/t/more-conditions-in-relations/60278/2 "2023-04-08T08:07:22Z")

</div>

For this calculation I use SUMIFS in excel.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [April 8, 2023, 12:32pm UTC](https://community.glideapps.com/t/more-conditions-in-relations/60278/3 "2023-04-08T12:32:52Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [April 8, 2023, 6:48pm UTC](https://community.glideapps.com/t/more-conditions-in-relations/60278/4 "2023-04-08T18:48:38Z")

</div>

Coming so soon!