I'm a newbie with Tableau and I'm trying to find the following information.
For Campaign Code = A2
I'd like to find out all the payments from A2 and thereafter, and the date for the first purchase. I think I've got the customers and minimum date down, but I'm having trouble with the Paid total.
For example, I have Customer Number 1 with an order on Campaigns: A1, A2, A2, A3 in that order and it will result in 35 total paid amount, but I only want 25 since I'm starting with Campaign A2.
Additionally, Customer Number 4 only has an order on Campaign C1 so they should not appear in my final results.
I'd like the following results
Then, how would I deal with this case where the initial campaign can be A2 or A1, so Customer Number 1 would have results A1, A2, A3 and Total Paid Amount of 35?
Thanks so much!