I have this table called Facturació:

enter image description here

The image shows the result i’d like to achieve, that is, the column Nº Factura (Invoice number) is a concatenation of the year taken from the DataFactura field (year(DataFactura)) and an incremental number that resets to 1 when year(DataFactura) changes. How can I achieve this?

Thanks for your help!