Hi all
I have a table with Customer ID, First Order Date and another table with Date, Customer ID and Dispatch
I select a period of Dates and I create vStartDateTY=min(Date) and vEndDateTY=max(Date)
I want to assign to each customer the label of "new" if her first order date is between vStartDateTY and vEndDateTY or "existing" otherwise.
Then I want to create a table on the sheet that aggregates dispatches per "new" and "existing". What do I put as dimension? I know that Dispatch should me the measure.
Can you help?
George