Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a question about SET Analysis with the Possible or Exclude function. I've a set of sales per month. Each month a set of products. I want to know how many products I sold in previous period, but NOT in the current period. So I want to use the Exclude function. When I want to know how many products are not sold in Period 2, I use this code:
count( distinct {$< Product = E( {$< Month = {2} >} ) >} Product )
But I want this for a rolling year. In period 2 I want to compare it with period 1, in period 3 with period 2 etc.
Pls. can you help me?
Try this:
count({$<Year={$(=Year(AddMonths(Today(),-1)))},Month={$(=num(month(AddMonths(Today(),-1))))},
Product=E({$<Year={$(=Year(Today()))},Month={$(=Num(Month(Today())))}>} Product)>} distinct Product)
You need to use the Addmonths with Year() and Month() to account for December to January.
Hi @Anonymous,
Thank you for your solution. This is not were I was looking for. I want a solution where I have a table with dimension month and then every month the missing products in that month, compared with the previous month.
Look at my attachment for a the model.