Tuto WINDEV 25

228 Part 4: Full application with data ▶ To calculate the sum of values of "Orders.TotalIOT": 1. Select the "Orders.TotalIOT" item in the middle. 2.  In the "Actions", on the right, select "Sum". The sum description window appears. 3. Validate the sum description. The sum of "TotalIOT" was added into the list of query result. Remark You will notice that the query editor of WINDEV creates the queries in everyday’s language (and also in SQL language). This allows you to check the purpose of your query. ▶ We are now going to group the data by year and to sort it: 1. Select the "Orders.Date" item in the middle.