Need to get sales in selected weeks and not sold in last 2 years preceding the selected weeks?

[nenadvukovic]

Hi,

I have sales details at the very granular level (invoice line) for last 3 years and need to identify customers who have had new SKU combinations sold to them in the last 6 weeks, for example, but never sold in the last 2 years preceding those 6 weeks, along with quantities, number of SKUs and totaled by product sub-family.

The end result should look something like this:

Customer A          Product Subfamily X      New SKUs: 4         Total pieces sold (of new SKUs)      200

Customer B          Product Subfamily X      New SKUs: 10       Total pieces sold (of new SKUs)      100

Is Alternate States a better choice here?

Or, to create new internal table?

Thanks for sharing the best approach

[d_pranskus]

Hi Could you scramble your file and attach in a message here? Thanks

[nenadvukovic · Accepted solution]

I believe I got it right:

Sold in last N days: sum({$<Date = {">=$(=date(today() - $(vDays)))"}>} Qty)

Sold before that: sum({$<Date = {"<$(=date(today() - $(vDays)))"}>} Qty)

Now, how can I eliminate lines where "Sold before that" = 0?

Thx