hi,

do you know how can I calculate YTD sale, but only for customers that on the day of sale had been our customer for at least 12 months.

so, the sales happen every day and we calculate new customers, as the ones that have been buing for at least 12 months (at least one transaction). So, if the first sales heppend (on particualr customer) 11 months ago, it is new customer sales, but on the same customer sales that happened 12 months and 1 day ago, it is considered as "old" customer.

therefore in my goal calculation, one customer's sale can be both, in new and old customer base. I know how to make YTD sale calculation, but have no idea how to add to it that like-for-like index