'Is there a way to filter information from a view and display them in the same view?

two months ago i asked this Question: How do i write more complex code in Lotus Notes views. My View now looks like this:

Year Month Device Counter Times(Minutes) Times(Hours)
2021
January
Test 01 270 4,5
Test 02 210 3,5
Test 01 60 1
Test 01 90 1,5
February
Test 01 30 0,5
Test 02 180 3
Test 01 60 1

The Database sets a new Document every time a Device is lend out. What i want to do now is to read trough every document and combine "Times(Minutes)" and "Times(Hours)" inside an variable, and also save each device name one time.When a device name is scanned more then once, the counter will go up by one. In my Lotus script program i did this using a Multi-Dimensional Array.

I Want to do this because i want to display each Device only One Time. Then each device has the combined values inside the "Times" Columns, and a counter to show how often the Device has been lend out in the chosen month. It should look like this:

Year Month Device Counter Times(Minutes) Times(Hours)
2021
January
Test 01 3 420 7
Test 02 1 210 3,5
Feburary
Test 01 2 90 1,5
Test 02 1 180 3


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source