Show first order for a customer

Question

How to show first-order sales for each customer?

Answer 1

Hi Nithin,

Use the calculative field as below,

IF[Order Date]={ MIN([Order Date]) } THEN [Sales]
END

This would fetch you the order for each customer.

Now drop customer in the sheet and above created field and order-date field.

Hope it helps you.