Set analysis associated field

[juriengroot]

Hi,

I have a master calendar:

Load 

...

  (Year(TempDate)-1) * 12 + Num(Month(TempDate)) as MonthID,

  MonthName(TempDate) as Period

The user can select one Period in the app. I have two metrics:

Sum( {$<[MonthID]={$(=Max([MonthID]))} >} Money)

Sum( {$<[MonthID]={$(=Max([MonthID])-1)} >} Money)

If the user selects one Period, the 2nd metric shows 0. How can I let the user select one period and still show (essentially Period-1) via the monthID -1 ?

If I select one MonthID it works fine. Why can the set analysis not understand the associated field?

I don't want to have a data island btw.

[swuehl · Accepted solution]

It does understand the associated field, but the user selection is incompatible with the field modifications. You need to clear the user selection in the Period field:

Sum( {$<[MonthID]={$(=Max([MonthID])-1)}, Period=  >} Money)