Set analysis

[stephenedberkg]

i have two calendar one for uploading month and year and another one is forecast month and year

in my dashboard i made uploading month and year as calendar

but the above screen shot values is wrong

each code have some lock period like 1,2,3.

since code CP6426 has lock period as 2 i want the march sales values

i want achieve this without clicking march.

my expression is =sum({<Years={$(=Max(Years))},MonthIDS = {$(=Max(MonthIDS))}>}Sales)

how to write this logic in set analysis

[tresesco]

Is 144 your expected output when selecting Month-Jan, ID-2? If so, try like:

=sum({<ID,Month,Years={$(=Max(Years))},Months={$(=Month(Addmonths(Max(UploadDate),$(vLockPeriod))))}>}sales)

[stephenedberkg]

no i want display 53.

we should not add two month sales values,we want to add only the month with lock period

[tresesco]

=sum({< ID,Years={$(=Max(Years))},Months= {$(=Month(Addmonths(Max(UploadDate),$(vLockPeriod))))}>}sales)

[stephenedberkg]

=num(Sum({$< UYear = {$(=Max(UYear))} ,UMonthID = {$(=Max(UMonthID))},FMonthIDS={$(=max({$< UMonthID = {$(=Max(UMonthID))}

,UYear = {$(=Max(UYear))} >}FMonthIDS) )} > } sales),0.00)

i wrote like this

[stephenedberkg]

tresesco‌

it is correct but when id is selected only its displaying the values.

when it is not selected the values is zero but i cant show like this in dashboard.

[tresesco]

Let us know what is your expected output when ID is not selected.

[stephenedberkg]

for jan my output is should be 225 without selecting the id