How to get max date with conditions (Fiters)

Hi Experts,

Here I need to get customer’s recent date along with their different products (ex: 5 products are product list ) , so I need to write calculated field which should give Max date with conditions (on Products)

I have written following calculation but its not working
maxIf( {order_date}, {product_category} = ‘Consumer’ AND
{Product_name} = ‘bottle’)

I want customer name recent purchase date, kindly help me
thanks

What is off?

Can you show me a screenshot of what you are expecting versus what you are seeing?

1 Like

Hi @gururajgiri

We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 3 days, we will archive the question.