You can create a 'True/False' calculated field using 'IF' function. Later you can pull this field to filter box and select only 'true' values.
Ex: IF count(SaleDate)>1 and SaleDate<PromotionSendDate then "TRUE"
-Place this on the filter box and select "TRUE".
This should solve your problem.
This is possible but will have more than one method and which are available will depend on the structure of your data, do you have a sample source?
The below formula will tell you if the sale was made before or after a promotional period.
IF [SaleDate] > [PromotionSendDate]
THEN 'Bought after Promotion'
A filter for customer name could be placed on [Number of Records] > 1 to exclude any first time customers.
An index() calculation could then be added to the view to highlight customers first sale so you don't look at those..
If you could provide a sample workbook I will be able to help further
I'm afraid that your IF mixes aggregate and non-aggregate terms so it won't work
Thanks! I'll try that.
How does the index() function work?
I'm afraid I can't give an example workbook, because I don't think I can recreate the underlying tables the way I have them with fictional data.
INDEX() Returns the row number of the item in the window ( it is a table calculation ). You can utilitise this by Compute using Pane and adding it to the filter shelf and excluding 1, if your data is arranged in date order it will exclude the first item for each customer. But it depends on the structure of your data and how you wish to display as to the exact method I would recommend