How to present a screen with summary totals

[John-504b]

I have a table, collections. One column for a date, one for a product type, and one for quantity.

I would like to have a screen where user can enter a date range, then will display totals for each product type in that range. Is this possible? tia

[aj]

Hello @John-504b, welcome to the community! Great question you have and I'll take a crack at providing some guidance. Below is a sample app that I built with the functionality I believe you are asking for:

1. I have two tables, Collections and Types:
   
   
   
   
   
2. One app with one screen with the following:
   
   
3. Start date and end date data cells are simply date objects set as variables. For example, here's the start date properties.
   
   
   
   
   
4. Then I have a list object with the following expression: =FILTER(Collections,"Collections[Date]>=% and Collections[Date]<=%",$[StartDate],$[EndDate])
   
   
5. And that's it! Here it is in action:
   
   

Hope this helps!