Skip to main content

Looking to display the last order date of a customer

  • November 27, 2020
  • 4 replies
  • 48 views

Forum|alt.badge.img+2

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

Kamille_Parks11
Forum|alt.badge.img+27

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


Forum|alt.badge.img+2
  • Author
  • New Participant
  • November 27, 2020

@Kamille_Parks how do I do that?


Kamille_Parks11
Forum|alt.badge.img+27

@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.


Forum|alt.badge.img+2
  • Author
  • New Participant
  • November 27, 2020

@Kamille_Parks it returns 0 for all cells