set analysis issue

[singhcv123]

Hi ,

I want to create a set analysis with below data:

Fields Name  : Period Number , Year , person

Set analysis for Current Period

Count( {<$Period Number =>}Person)

In Second Set Analysis i want to pick the period code --1 from above value

Count ({<Period Number = {$(Period Number -1 }>}Person)

and in 3rd i want the same period number but last year

Count ({Period Number = , Year ( Addyears(Today()-1)}Person)

Kindly suggest the right combination....i am not getting right outcome from the same..................

[swuehl]

Try

Count ({<Period Number = {$(=Max(Period Number) -1)}>}Person)

resp.

Count ({<Period Number = {$(=Max(Period Number))}, Year = {$(=Max(Year)-1)}>} Person)

[sunny_talwar]

Do you have a sample you can share? Are you using this in a text box object or a chart? If it is a chart what is your dimension? Period Number?

[Chanty4u]

chk dis

Count ({<Period Number = {$(=Max(Period Number) -1)}>}Person)

[Kushal_Chawda]

Current Period:

Count( {<[Period Number] = {"$(=max([Period Number]))"}>}Person)

Previous Period:

Count( {<[Period Number] = {"$(=max([Period Number])-1)"}>}Person)

Last Year:

Count( {<[Period Number] = {"$(=addyears(max([Period Number]),-1))"}>}Person)