To find the total value of purchases per day to dispense the staff commissions.
Filter the Time Range
Set the date field to the time range you would like a report on
Download the Report File
The file will download as an Excel file (.xls)
Go to the All Transactions Tab
This example is in Google Sheets, but you can also use Excel
Format the Total Price Column
Format it as currency, so it looks better
Create a Pivot Table
Highlight the whole spreadsheet, go to the Data tab and choose Pivot Table
Click Create
Edit the Pivot Table
To get the Total Purchased Value by Day- Add a Row and choose Date
- Add a Value and choose Total Price
If your Date is in a format that is not recognized you need to change the format.
Change the Date Format
For example, 2021-01-01T00:00:022 you only need the first 10 characters
- Add a column and name it 'Actual Date'
- Take the left 10 characters from the first column using this formula =left(A2,10)
- Change the number 10 based on how many characters you need
- Copy that formula for all of the rows
- Adjust the Pivot Table Rows to use the Actual Date column instead of the Date column