Get latest order for a customer

[MacaulayGidado]

My first table is a list of orders with a date and a customer name that is linked to the customer table I need to display the date of the last order on the customer table.

[Kamille_Parks]

Use a Rollup field with a MAX(values) aggregation.

[MacaulayGidado]

@Kamille_Parks how do I do that?

[Kamille_Parks]

Go to your Customers table, make a Rollup field, select the orders Table, select the Order Date field, enter MAX(values) as the aggregation.

[MacaulayGidado]

@Kamille_Parks it returns 0 for all cells