Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Re: Looking to display the last order date of a customer

1246 0
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
Kamille_Parks
16 - Uranus
16 - Uranus

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