4 Replies Latest reply: Mar 30, 2016 7:40 AM by kushal chawda

# set analysis issue

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..................

• ###### Re: set analysis issue

Try

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

resp.

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

• ###### Re: set analysis issue

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?

• ###### Re: set analysis issue

chk dis

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

• ###### Re: set analysis issue

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)