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