Last date in a table

[sebastian_heche]

Hello everyone, I have a question about the  data type: date in Looker.

I need to show the last date where a product has been sold in a table. 

For example, I have a product and a lot of columns, including product information, sales amount,  number of pieces bought (purchases) and more. I show the date, but I need the date of the last sale and the date of the last purchase.

This table that I get isn’t what I need, because it shows all the days in wich there has been sales. I need that the table shows only one data row per product and only the last date in wich there has been a purchase and a another data row that shows the last date in wich there has been a sale.

I tried with MAX( ) in semantic layer but the field doesn’t work.

I tried too with table calculations and custom filters, but it is difficult to work with dates on those tools.

Thank you in advance. 

I look forward to hearing from you soon, 

Best regards.