Forum Discussion
Second Last Transaction Date without filters
Community ChampionAre you saying the formula you have shown here is a calculated column? You should use it as a measure and it should work. I see no issue with other filters being applied.
It is a measure and it does work, but not in the way that I intend. Here is a specific example to illustrate:
We have regional offices who will often filter reports based on the region in which the transaction was processed (financial_region). So let's say a customer has transactions in 2 financial regions as follows:
cusomer_id transaction_date transaction amount financial_region
453827 1/21/2018 200 WEST 453827 3/12/2018 150 CENTRAL 453827 4/5/2018 100 WEST If someone is looking at a report with only financial_region = CENTRAL selected, then the measure I posted returns nothing because there are no transactions in the CENTRAL region prior to the one on 3/12/2018.
The desired behaviour would be to get the second last transaction date of the all the transactions for a particular customer_id regardless of what filters are applied to a report.
