Possible function issue in set analysis

[ashokraju]

Hi 

I am using possible function in set analysis but it is not working based on month dimension.

My scenario is if a salesrep belongs to particular state then i am bringing user count for all the states.

count(  {< salesrep=p(state) , date={>=startdate<=enddate} >}  users)

and in straight table iam showing

month,state as dimension and expression as --> count(  {< salesrep=p(state) , date={>=startdate<=enddate} >}  users)

if i select single month in the top filter it is showing correct value
but if i select last six months possible function is evaluating based on six months and it is not aggregating with month as jan, feb,mar,apr..so on..

it is showing entire six months sales rep count in each month.

It would be great if anybody can guide us

[MendyS]

hi

Have you tried using the AGGR function?

something like  - Aggr(count(  {< salesrep=p(state) , date={>=startdate<=enddate} >}  users),Month)?