Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Looking to display the last order date of a customer

Topic Labels: Formulas
1258 4
cancel
Showing results for 
Search instead for 
Did you mean: 
MacaulayGidado
4 - Data Explorer
4 - Data Explorer

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.

4 Replies 4

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

MacaulayGidado
4 - Data Explorer
4 - Data Explorer

@Kamille_Parks how do I do that?

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
4 - Data Explorer
4 - Data Explorer

@Kamille_Parks it returns 0 for all cells