Hi Dayana,
If the total application an existing column in the same form with the department column?

if that's the case .
You can just drag and drop the 
Application Column and the Department Column in the List builder. 

However,
If both of the columns are from different forms(Which from different tables)
you can make use of the Advanced Form Data List Data Store

You can join both of the tables .
You can also make use of the Aggregate Query if you want to display sum for the specific column.

Hope it helps.

yes, but i want to display the total by department

Okay.then maybe you can have the department to be as a filter.

Then You can filter out according to the department that you want only.

You can only see the application total based on the department that you have filtered out only?.

ginger, can you help me, i try to do the datalist using sql but it appear error : ERROR 19 Jul 2024 15:05:13 /jsp/dbuilder/dataListView.jsp - Error rendering datalist

Dayana,
Change the data store and you can Try to use the aggregate query to have the application column to be count up using the existing feature?
try to have it a go. 

By the way, the process_id column, is it in the same form?
Or is it from different one?