# Filtering Data Based in month from Multiple tables

**URL:** <https://community.glideapps.com/t/filtering-data-based-in-month-from-multiple-tables/69938>\
**Category:** Ask for Help\
**Created:** [January 24, 2024, 12:34pm UTC](https://community.glideapps.com/t/filtering-data-based-in-month-from-multiple-tables/69938 "2024-01-24T12:34:07Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [January 24, 2024, 12:34pm UTC](https://community.glideapps.com/t/filtering-data-based-in-month-from-multiple-tables/69938/1 "2024-01-24T12:34:07Z")

</div>

I have two tables taken from airtable “Conversations\_Brand” and “Invoices\_Jan”  
Both of them have a Created Data column in them.

“Conversations\_Brand” also has a dropdown called status which has two option “Confirmed” and “Negotiation”

I have another View called Dashboard which gives me the total of filtered data from Invoice and Conversations based on status.

Right now I am able to get the totalled data from these tables based on selected status for particular user.

I Will place a range picker in my Dashboard screen. how do I get to pick data from multiple sources

[https://www.youtube.com/watch?v=AVSavEhdt6Y](https://www.youtube.com/watch?v=AVSavEhdt6Y) I have followed this tutorial. I have got filter working. But how do I make the change to get the selected status values total from the table with name “Conversations\_Brand”

I have got everything set up even getting data from multiple tables to be displayed. Just need help in getting Status specific dat from “Conversations\_Brand”

EX: I need total Number of status “Confirmed” and total number of status with value “Negotiation” in the table with name “Conversations\_Brand”

Thank you in advance for the help