Unique fields data

Question

Hi, I want to show the first order bought by customer in a period of time. Should i use filter? How to do this? I'm using global superstore data set.

Answer 1

Hey,

use below calculated field -

{ FIXED [Customer ID] : MIN([Order ID])}

Now place customer id and the above field in the table to show first order by customer.