AGGR???

[#1]

Hello everyone:

I need help with the following. I have the following table:

Patent = Automobiles.

Date = Fuel charge date.

Branch = Place to which the car belongs.

The branch can change with the passage of time as for example can be seen in the patent AAA111.

The yellow rows are the ones you should select for the result (Correct rows).

I need to build a list where by branch I calculate the number of patents that are per branch ONLY taking into account the last charge of gasoline.

The rest should be:

I attached the excel table complete with the result.

From already thank you very much for the help.

[felipedl · Accepted solution]

Hi Martin,

Attached one solution, using joins with a flag on the max date for each field "Patente".

Hope it helps

Regards,

Felipe.

[#3]

Muy bueno!!! Se acerca mucho a lo que estoy necesitando. Voy a mirar si puedo adaptar el ejemplo al tablero que estoy armando y te comunico.

Muchas gracias!!! Excelente!

[felipedl]

Hi,

Didnt' see there was a excel file with the data you needed.

Attached is a QVW using the provided data.

Glad i'd helped

[#5]

USTED ES DIOS !!!!

Muchas muchas muchas gracias!!!!