How can I get the total item count

I have two sections, “items delivered” and “total items delivered”. How can I get a total count of items that were delivered?

As different items are delivered, I’ll be adding them to the list.

Thanks ahead for any suggestions and of course solution.
Med Supplies.ods

In my opinion, this is once again a typical requirement for a database.


See also: [English documentation](https://documentation.libreoffice.org/en/english-documentation/)

the Base Guide

It can be done with a pivot table, select the data with the column names B2:E500, Menu/Insert/Pivot table, expand other options and select where you want to go, add ITEM_DESCRIPTION to Row fields, and add it to Data fields, double-click on the last and change to count.

Remember that pivot table doesn’t update automatically, you need to right-click on it and select refresh.