# Tally the $Total and group Orders by Order\_Date
**URL:** https://community.glideapps.com/t/tally-the-total-and-group-orders-by-order-date/9463
**Category:** Ask for Help
**Created:** [May 20, 2020, 4:33am UTC](https://community.glideapps.com/t/tally-the-total-and-group-orders-by-order-date/9463 "2020-05-20T04:33:52Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Rogelio](https://community.glideapps.com/u/Rogelio)
#### Post date: [May 20, 2020, 4:33am UTC](https://community.glideapps.com/t/tally-the-total-and-group-orders-by-order-date/9463/1 "2020-05-20T04:33:52Z")
I have a sheet that contains all orders that have been processed including the $Total, Order Date, etc… for each.
I need to display a daily summary of the total amount of all orders processed for the day.
I really want to steer away from creating formulas as performance wise it can get really slow when doing complex calculations, so Is there a way to achieving this within Glide?
---
### Author:  [@Petr\_Shemyagin](https://community.glideapps.com/u/Petr_Shemyagin)
#### Post date: [May 20, 2020, 5:06am UTC](https://community.glideapps.com/t/tally-the-total-and-group-orders-by-order-date/9463/2 "2020-05-20T05:06:59Z")
If I understand your task correctly, I heve managed to do it in the following way:
1. Create text entry at the page where results are needed. In my case it is tab “Purchase statistics”, column “Date text”
2. Create relation column that will relate the date from “Date text” with order dates in the list of orders.
3. Use rollup based on this relation column to calculate total amount
---
### Author:  [@Rogelio](https://community.glideapps.com/u/Rogelio)
#### Post date: [May 20, 2020, 5:36am UTC](https://community.glideapps.com/t/tally-the-total-and-group-orders-by-order-date/9463/3 "2020-05-20T05:36:24Z")
that doesn’t work as timestamps are recorded as `2020-05-12T23:22:46.120Z` so when creating the relation it doesn’t find any matching rows as it is not the exact timestamp (including hours, mins, secs).
---
### Author:  [@Petr\_Shemyagin](https://community.glideapps.com/u/Petr_Shemyagin)
#### Post date: [May 20, 2020, 5:38am UTC](https://community.glideapps.com/t/tally-the-total-and-group-orders-by-order-date/9463/4 "2020-05-20T05:38:53Z")
That is why in the first point I have written “Text entry”. It can look like this: "Input purchase date (dd.mm.yyyy)
---
### Author:  [@Petr\_Shemyagin](https://community.glideapps.com/u/Petr_Shemyagin)
#### Post date: [May 20, 2020, 5:41am UTC](https://community.glideapps.com/t/tally-the-total-and-group-orders-by-order-date/9463/5 "2020-05-20T05:41:09Z")
I got it, I have forgotten about one more thing. You should use “TEXT” formula in excel to make it working and to take only date from the whole date+time entry and then relate this column to your text entry column
---
### Author:  [@Rogelio](https://community.glideapps.com/u/Rogelio)
#### Post date: [May 20, 2020, 6:25am UTC](https://community.glideapps.com/t/tally-the-total-and-group-orders-by-order-date/9463/6 "2020-05-20T06:25:43Z")
thanks, this has achieved the objective, albeit a little clunky having have to type out the date.
Ideally, I want to have a card view display totals where ever there was a sale on any day, this is so the user could easily scroll up/down and view the total sales without having have to enter the date each time.