set analysis expression help?

[Vidit]

Hi,

What should be changed in the following set analysis expression, that the count for previous quarter also changes with select in DIV field?

expression used

sum({$+1<[Prod] = {'D'},PeriodNum={$(=Max(PeriodNum)-1)}>}Count) 

Please suggest?

[Chanty4u]

try

sum({$+1<[Prod] = {'D'},PeriodNum={"$(=Max(PeriodNum)-1)"}>}Count)

[Vidit]

The expression I have mention is working the issue is for

<[Prod] = {'D'},PeriodNum={$(=Max(PeriodNum)-1)}>}

this part of expression it doesn't work for DiV filter

[rubenmarin]

Hi Vidit, can you try?:

sum({$+1<[Prod] = {'D'},PeriodNum={$(=Max(PeriodNum)-1)}, DIV=P(DIV)>}Count)